Excel Forum
Similar Content
Stop Excel Transformations of Imported Data (2 Simple Tips)
Tutorial: Prevent Excel from changing data that you import, including long numbers, text that looks...
Sum Values from Every X Number of Rows in Excel
Tutorial: Add values from every x number of rows in Excel. For instance, add together every other va...
Convert Numbers into True and False in Excel
Tutorial: How to convert numbers into the TRUE and FALSE Boolean values in Excel. This is very impor...
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 #118: Reverse 2-Way Lookup Part 2


Watch Part 1 first. This Part 2 gets very complicated, but it is quite cool: See the functions, IF, INDEX, MATCH, SMALL, TEXT, 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.