Download Excel File: [ Ссылка ]
Learn how to create two different formulas for Discounted Sales: 1) A Standard Formula that requires VLOOKUP, Locked Ranges and a Copy Action, or 2) XLOOKUP and Spilled Arrays.
1. (00:01) Introduction
2. (00:15) Formula #1: A Standard Formula that requires VLOOKUP, Locked Ranges and a Copy Action
3. (02:23) Formula #2: XLOOKUP and Spilled Arrays. This formula does not require that we lock ranges or copy the formula.
4. (04:44) Summary and End Video Links
