Sorry- I don't have much here yet- check back later for tips on Vlookup and Index Match and other lookups.

I've been working on a lookup manual that was just added to the course course catalog. VLOOKUP, HLOOKUP and INDEX MATCH but thought I would mention the LOOKUP Wizard here.

Excel offers a Lookup wizard which will easily retrieve a value from a worksheet if the data is contiguous and all the values are unique. It is a nice way to start if you are not familar with lookup functions. It is based on the Index Match function.

It doesn't work in all cases particularly if you have repetitive data

This Wizard is an Add-in Program and does need to be added into Excel. [If you are not familiar with Add-in programs, go to Help in Excel].
Once you have done so

•  in Excel 2003 go to Tools>Lookup
• in Excel 2007 go to the Solutions tab  and click on Lookup.

The Wizard will walk you through the 4 steps.
 

Back 
CPASelfStudy.com