Download Excel File: https://excelisfun.net/files/EMT1694.xlsx
Learn how to use XLOOKUP and the left function to extract elements from left in lookup table to make match so you can retrieve elements from the first column in the lookup table (left of the array_lookup range). See XLOOKUP method and an old school INDEX and MATCH method.
The formula solution helps when you have to lookup an item from the first column of the lookup table.
Learn about how to convert text numbers to numbers so lookup will work.
Topics:
1. (00:00) Introduction.
2. (00:26) What is double lookup left?
3. (00:47) XLOOKUP and LEFT function solution
4. (03:15) INDEX, MATCH and LEFT solution.
5. (04:58) Summary, Closing and Video Links