Download Excel File: https://excelisfun.net/files/EMT1649.xlsx
This is a follow up video to Excel Magic Trick 1648 (EMT 1648). Excel Wizard at YouTube shows us how to create a Dynamic Range using the INDEX Function so that our formula can use one of two Lookup Tables. Also see 3 bonus formulas.
1. (00:01) Introduction & Look back to Excel Magic Trick 1648
2. (00:36) INDEX to create Dynamic Range, then LOOKUP with Absolute & Relative Cell References
3. (03:05) Dynamic Spilled Array Formula with INDEX & LOOKUP
4. (03:33) IF to create Dynamic Lookup Table
5. (03:41) SWITCH to create Dynamic Lookup Table
6. (03:50) Summary and End Video Links