Excel Forum

Excel Magic Trick 398: VLOOKUP with Two Lookup Values (IFERROR function also) 2 lookup values

See how to use the VLOOKUP function when you have two lookup values for each record. Learn how to use the IFERROR function also, and how to join two cells to add a new first column to the lookup table for the VLOOKUP function. Ampersand symbol to join cell content.

VLOOKUP with Two Lookup Values
VLOOKUP with 2 Lookup Values
VLOOKUP with Two Lookup_Value
VLOOKUP with 2 Lookup_Value

Got a Question? Ask it Here in the Forum.