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...
Partial Match Lookup with Numbers in Excel
Tutorial: Perform lookups on numbers with partial matches. For instance, find the first number that...
Delete Duplicate Values in All Versions of Excel
Tutorial: How to delete duplicate values from a data set in all versions of Excel.  This includes Ex...



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.