Main Profile

At A Glance

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.
Length: 05:43

Contact

Questions about Excel Magic Trick #118: Reverse 2-Way Lookup Part 2

Want more info about Excel Magic Trick #118: Reverse 2-Way Lookup Part 2? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question