Excel Magic Trick 1259


Can VLOOKUP Lookup Duplicates? Yes! Helper Column or Array Formula?
Learn how to use two lookup values to lookup an item in a table:
(00:11) Problem Introduction and discussion of default behavior for VLOOKUP for Exact Match.
(01:00) Helper Colum Solution with Joined Values to create Unique Identifier in First Column. VLOOKUP and Joined Lookup-Value.
(03:01) Single Cell Array Formula with INDEX and MATCH functions and an array operation using the join symbol. Array Formula that requires Ctrl + Shift + Enter.
Array Formula that does NOT requires Ctrl + Shift + Enter. Using INDEX array argument to avoid Ctrl + Shift + Enter.