Published On Jan 20, 2016
Download Excel Start File: https://excelisfun.net/files/EMT1258-...
Download File: https://excelisfun.net/files/EMT1258-...
Learn how to use two lookup values to lookup an item in a table:
1. (00:11) Problem Introduction and discussion of default behavior for VLOOKUP for Exact Match.
2. (01:00) Helper Colum Solution with Joined Values to create Unique Identifier in First Column. VLOOKUP and Joined Lookup-Value.
3. (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.
4. Array Formula that does NOT requires Ctrl + Shift + Enter. Using INDEX array argument to avoid Ctrl + Shift + Enter.