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...
Partial Match Lookup with Numbers in Excel
Tutorial: Perform lookups on numbers with partial matches. For instance, find the first number that...
Vlookup on Dates and Times in Excel
Tutorial: Perform a lookup on dates and times in Excel: vlookup, hlookup, index/match, any kind of l...
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 #149.5: Reverse 2-Way Lookup w Duplicates


This video is in response to the video: Excel Magic Trick #118: Reverse 2-Way Lookup Part 2.
See how to do a Reverse 2-Way Lookup w Duplicates regardless of whether the first occurrences of a value is in a higher or lower row than subsequent occurrences. See the functions: TEXT, COLUMN, COLUMNS, IF, INDEX, MATCH, MAX, SMALL, CHAR functions.

See how to take a value in a table and then return the row or column value.

ALSO: SEE HOW TO USE THE COLUMNS FUNCTION TO INCRENETENT NUMBERS (1, 2, 3) IN A FORMULA.

See how to use the F9 key to see how an Array Formula works.





Got a Question? Ask it Here in the Forum.