Exercises / Lookups · 9 of 10
Shipping cost by weight bracket
XLOOKUP's fifth argument, match_mode, controls what counts as a match: 0 exact, -1 exact or the next smaller item, 1 exact or the next larger. Unlike VLOOKUP, the table does not have to be sorted.
Your taskEach row of E2:F6 is the cost from that weight up. In C2, use XLOOKUP to return the shipping cost for the weight in B2. It will be copied down to C8.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Parcel | Weight kg | Cost | From kg | Cost | |
| 2 | PK-1 | 0.4 | 0 | $4.50 | ||
| 3 | PK-2 | 3.2 | 1 | $6.90 | ||
| 4 | PK-3 | 1 | 5 | $9.80 | ||
| 5 | PK-4 | 12.5 | 10 | $14.20 | ||
| 6 | PK-5 | 7.8 | 20 | $22.00 | ||
| 7 | PK-6 | 24 | ||||
| 8 | PK-7 | 0.95 |