Download Excel File: https://excelisfun.net/files/EMT1648.xlsx
Learn how to change the first column in a lookup table when there are two possible First Columns for Matching with the Lookup Value. The goal is to indicate with a 1 or a 2 whether we want the first or second column in the lookup table to be the column the formula uses for matching against the lookup value to determine the row for the final column in the lookup table so we can retrieve the value and bring it back to the cell. We can think of this as 1) “Looking Up one of two first columns”, or as a formula that has “Two Lookup Tables. See the Excel Lookup Functions: INDEX, MATCH, XLOOKUP, LOOKUP or CHOOSE.
1. (00:01) Introduction.
2. (00:29) Concept: “2 First Lookup Table Columns?” or “2 Lookup Tables?”.
3. (00:45) INDEX, INDEX, MATCH Formula #1.
4. (02:23) XLOOKUP & INDEX Formula #2.
5. (03:01) LOOKUP & INDEX Formula #3.
6. (03:32) LOOKUP & CHOOSE Formula #4.
7. (04:46) Summary and End Video Links