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 Ma...
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 VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.