Download Excel File: http://excelisfun.net/files/EMT1695.xlsx
Jam Packed Video with 3-way lookup, XLOOKUP function to lookup cell reference, and complex logical formula for three way conditional formatting.
Topics:
1. (00:00) Introduction.
2. (00:18) Why we need to lookup a cell reference.
3. (00:56) First XLOOKUP
4. (01:25) Colon Operator and second XLOOKUP.
5. (02:28) Third XLOOKUP to complete 3-way lookup.
6. (03:18) Old School formula using INDEX and MATCH functions.
7. (04:08) Conditional Formatting for 3-way lookup using the AND, COLUMNS and XMATCH functions and Mixed Cell References.
8. (09:05) Summary, Closing and Video Links