A revenue analyst's discount tracker has gotten slow. The original pattern is one VLOOKUP per row — fine for 8 rows here, but in production this sheet runs to ~5,000 rows and recalc is sluggish:
D2: =VLOOKUP(C2, $G$2:$H$5, 2, FALSE)
D3: =VLOOKUP(C3, $G$2:$H$5, 2, FALSE)
D4: =VLOOKUP(C4, $G$2:$H$5, 2, FALSE)
... (one formula per row, dragged)
Your task:
- Replace this with a single formula in D2 that spills down the entire result column. With XLOOKUP, you can pass an array as the lookup_value and Excel spills one row of result per input.
Tier discounts:
| Tier | Discount |
|---|
| Bronze | 0 |
| Silver | 0.05 |
| Gold | 0.10 |
| Platinum | 0.20 |
Graded cells: D3, D5, D8.
Open this problem on a desktop to attempt it.