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 Mat...
Prevent Duplicate Values in Excel
Tutorial: I show you how to prevent duplicate values being entered into Excel using Data Validation...
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...



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.