Doing Automated Table Lookups
How to automate lookups in a worksheet table. The magic of being able to retrieve values from long boring schedules of numbers for use in other formulas without having to actually find the cell reference myself was quite thrilling. (It doesn't take much to get geeks like me happy.) The only problem is that that the lookup functions that do this magic are considered to be "advanced" functions and therefore a bit scary to new users.
In addition to covering the use of both the VLOOKUP (vertical lookup) and HLOOKUP (horizontal lookup) functions - each of which can retrieve a single value from a table of data - also introduce the Lookup Wizard, one of the add-in programs that comes with Excel that you can use to look up two values in the table.