Hi Brazzell Marketing,



I'm not aware of any tutorials, but the lookup functions are not difficult to master. However, they do require the lookup data (in this case, the column in the smaller workbook that is used to reference the data) to be sorted. If the data are not sorted, a different approach is required.

The attached workbook has data in columns A & B, some 'lookup' values in D and two different formulae for doing the lookups in E and F. As you will see, the LOOKUP formula in E makes false positive matches when the 'lookup' values in D aren't found in column A. The INDEX/MATCH pair in column F don't do that (they return a #N/A result instead); they also work with unsorted data.

Attached Files

Lookup.xls (19.5 KB, 22 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]