Download Excel File: https://excelisfun.net/files/EMT1810.xlsx
Learn how to do a 3-way or 2-way lookup in the Excel worksheet with XLOOKUP or in Power Query (in Excel and Power BI) using UnPivot and Merge.
Topics:
1. (00:00) Introduction
2. (00:05) 3-way lookup in the Excel worksheet with XLOOKUP
3. (01:45) 3-way in Power Query (in Excel and Power BI) using UnPivot and Merge
4. (03:46) Summary, Closing, Video Links