Main Profile

At A Glance

Excel Magic Trick #149.5: Reverse 2-Way Lookup w Duplicates

This video is in response to the video: Excel Magic Trick #118: Reverse 2-Way Lookup Part 2. See how to do a Reverse 2-Way Lookup w Duplicates regardless of whether the first occurrences of a value is in a higher or lower row than subsequent occurrences. See the functions: TEXT, COLUMN, COLUMNS, IF, INDEX, MATCH, MAX, SMALL, CHAR functions. See how to take a value in a table and then return the row or column value. ALSO: SEE HOW TO USE THE COLUMNS FUNCTION TO INCRENETENT NUMBERS (1, 2, 3) IN A FORMULA. See how to use the F9 key to see how an Array Formula works.
Length: 10:00

Contact

Questions about Excel Magic Trick #149.5: Reverse 2-Way Lookup w Duplicates

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

  • Answer

Ask a New Question