Task 1 of 2
In F2:F6, find each customer's discount from the scale on the left.
Lesson theory
If the last argument of VLOOKUP is 1 (or omitted), the function does not look for an exact match.
It finds the largest value that is less than or equal to the lookup value instead. This is how scales work: discounts, taxes, bonuses.
An amount of $750 → the nearest threshold below it is $500 → a 3% discount.
The key rule: the first column of the scale must be sorted in ascending order.
=VLOOKUP(E2,$A$2:$B$5,2,1)Enter — commit · F2 — edit · F4 — $ in a reference · Ctrl+C/Ctrl+V — copy and paste · Ctrl+Z — undo
Esc or F6 — leave the sheet for the «Check» button · Shift+Tab in the first cell — back to the page