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...
Filter Results in Excel to Show Only Those that End With Specified Text or Words - AutoFilter
Macro: This free Excel macro filters data to display results that end with certain words, text, o...
Partial Match Lookup with Numbers in Excel
Tutorial: Perform lookups on numbers with partial matches. For instance, find the first number that...

Excel Magic Trick #225: 2 Way Lookup With Duplicates

See how to do a Two Variable Lookup When There are duplicates. See the INDEX, IF, ROW and MAX functions.

Also see these videos:
Excel Magic Trick # 158: VLOOKUP w 2 Variables As Criteria
Excel Magic Trick #136: 2 way lookup with VLOOKUP & MATCH
Excel Magic Trick # 159: VLOOKUP Duplicates 1st Column
Excel Lookup Series #11: INDEX & MATCH functions Example 1!
Excel Name Trick #7: INDIRECT function, Names and LOOKUP

Got a Question? Ask it Here in the Forum.