Excel Forum



Excel Magic Trick 606: INDEX & MATCH Two Lookup Values


See a formula that can lookup two 2 lookup values using the INDEX & MATCH functions and Concatenated (joined) columns for the lookup value and lookup table.
Response to:
Excel Magic Trick 398: VLOOKUP with Two Lookup Values (IFERROR function also) 2 lookup values





Got a Question? Ask it Here in the Forum.