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...
Prevent Duplicate Values in Excel
Tutorial: I show you how to prevent duplicate values being entered into Excel using Data Validation...
Delete Duplicate Values in All Versions of Excel
Tutorial: How to delete duplicate values from a data set in all versions of Excel. This includes Ex...
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: Reverse 2-Way Lookup No Duplicates


See how to take a value in a table and then return the row or column value when there are no duplicate values. See how to do a reverse two-way lookup when there are no duplicate values. Array formula that uses the functions: INDEX, MAX, IF, COLUMN functions.
Learn about how an Array formula can deliver the first number in the array or all the values in the Array.
This video is in response to the video: Excel Magic Trick #118: Reverse 2-Way Lookup Part 2





Got a Question? Ask it Here in the Forum.