Excel Forum
Similar Content
Best Lookup Formula in Excel - Index and Match
Tutorial: A lookup using INDEX and MATCH is like a VLOOKUP without the restrictions.  Index and Ma...
HLOOKUP in Excel
Tutorial: The Hlookup function allows you to scan a row from left to right in search of a value and ...
Vlookup Across Multiple Workbooks
Tutorial: How to use the VLOOKUP function across multiple workbooks in Excel. This will create a lin...

Excel Magic Trick 436: VLOOKUP W 4 Lookup Columns

See how to use VLOOKUP when the first four columns of the lookup table must be used for the lookup value. The data is badly setup up because it is an import into Excel from a database. See VLOOKUP, IF and IFERROR functions.

Got a Question? Ask it Here in the Forum.