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...
6 Useful INDEX MATCH Lookup Examples in Excel - Workbook Included
Tutorial: 6 Detailed examples of how to make and use Index/Match Lookup formulas and functions in E...
Vlookup Date Picker in Excel (Dynamic)
Tutorial: Make a dynamically updating vlookup date picker for excel that allows you to choose a date...
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 #117: Reverse 2-Way Lookup Part 1


Really Hard formula!!! See the functions, IF, INDEX, MATCH, SMALL, ROW, ROWS, COLUMN and COLUMNS all in one array formula.

See how to do a Reverse 2-Way Lookup with a complex Array formula.

See how to populate a list of names for patients with schedule book entries using this complex Array formula.





Got a Question? Ask it Here in the Forum.