|
Featured Tutorial
Featured Macro
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.
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.