Exercises / Lookups · 5 of 10
Two-way lookup in a rate grid
INDEX(grid, row, column) can take two positions. Use one MATCH to find the row and another to find the column, and you can read any cell of a grid by its labels.
Your taskIn H3, use INDEX and MATCH to return the shipping rate from the grid B2:E6 for the zone in H1 (rows) and the weight class in H2 (columns).
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 | G | H |
|---|---|---|---|---|---|---|---|---|
| 1 | Zone | 1 kg | 2 kg | 5 kg | 10 kg | Zone | Zone 3 | |
| 2 | Zone 1 | $4.90 | $6.20 | $8.90 | $12.50 | Weight | 5 kg | |
| 3 | Zone 2 | $5.60 | $7.10 | $10.40 | $14.90 | Rate | ||
| 4 | Zone 3 | $6.30 | $8.20 | $12.10 | $17.60 | |||
| 5 | Zone 4 | $7.40 | $9.60 | $14.30 | $21.20 | |||
| 6 | Zone 5 | $8.80 | $11.50 | $17.20 | $25.90 |