Excel Forum



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.





Got a Question? Ask it Here in the Forum.