Download Excel File: https://excelisfun.net/files/EMT1655.xlsx
Excel Music Video about the Transformative Power of Office 365 Excel, the New Excel Calculation Engine and Dynamic Spilled Arrays.
This video also shows an unbelievable Excel Trick for Two-Way Lookup Adding where the formula is required to do 3 separate 2-way lookups and then add the returned values.
The Music Video compares and contrasts the Old School Excel Formulas and the New School Excel Formulas. It also shows how the two can be used together, like with XMATCH and INDEX or LOOKUP and FILTER. See an amazing Bill Szysz formula at the end.