« A Sudoku Solver! | Main | Toolbar Crazy »
January 27, 2006
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
Posted by Dave at January 27, 2006 01:51 PM