Excel Forum

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.