Creating a 2-D Lookup Table
By combining INDEX and MATCH functions as shown below, we can create a lookup table whose data can be accessed by specifying the desired row and column values.
This is probably best applied where the lookup table is of fixed size - for example - calculation of sales commisions.
For tables that change on a regular basis - thus requiring constant updates of the lookup formulae, the Base application might be a better solution. Now if only I had more time to play around with that…
Here is a similar
example
July 23rd, 2007 at 5:06 pm
This is exactly what I expected to find out after reading the title Creating a 2-D Lookup Table. Thanks for informative article
August 18th, 2007 at 9:23 am
Hello, very nice, good Luck!
September 9th, 2007 at 5:24 pm
Many interesting information on your site - keep up good work
February 16th, 2008 at 12:16 pm
Creating a 2-D Lookup Table thanks for this post! Andy