AdvancedGeneral officeAbout 7 minutes
Sample data
| Row | A | B | C | D |
|---|---|---|---|---|
| 1 | Weight kg | Zone A | Zone B | Zone C |
| 2 | 1 | 8 | 11 | 15 |
| 3 | 5 | 12 | 16 | 22 |
| 4 | 10 | 18 | 24 | 33 |
| 5 | 20 | 28 | 38 | 52 |
Steps
Each formula is already filled in and calculated. Edit it and press Run to try your own version. Nothing is saved or uploaded.
Find the row for 10 kg.
Result
Find the column for Zone B.
Result
Use INDEX with both positions to read the price.
Result
Another combination: 5 kg to Zone C.
Result
Show a friendly message if the weight is not in the grid.
Result
What to remember
A two-way lookup is just INDEX with two MATCH functions: one for the row, one for the column.
Need Something Different? Let’s Talk.
Looking for different features or something built around your workflow? Share your idea with us.