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 Mat...
Return the Min or Max Value Using a Lookup in Excel - INDEX MATCH
Tutorial: Find the Min or Max value in a range and, based on that, return a value from another rang...
Vlookup to Return All Matching Results
Tutorial: Here is an Excel formula that will act like a Vlookup that returns every matching result ...



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.