INDEX-MATCH with MATCH in both directions
IntermediateShipping teams often keep delivery prices in a matrix, with one category listed by row and another by column. A two-way lookup pulls the value where those two labels intersect, which makes this pattern useful for rate cards, schedules, and pricing tables.
In this exercise, you'll use INDEX with two MATCH functions to return the correct shipping rate. One MATCH should find the row for the selected zone, and the other should find the column for the selected weight bracket.
A common pattern looks like this:
=INDEX(data_range, MATCH(row_value, row_labels, 0), MATCH(column_value, column_labels, 0))
Build your formula in B10 using the lookup inputs already provided in the query area. Return the shipping rate at the intersection of the chosen zone and weight bracket.
Need some help?
Hint 1
The INDEX array should include only the shipping rates, not the zone labels in column A or the weight headers in row 1.
Hint 2
Use the lookup inputs in B8 and B9. Match the zone against A2:A6, match the weight bracket against B1:E1, and use those two positions to return the value from B2:E6.
INDEX-MATCH with MATCH in both directions
IntermediateShipping teams often keep delivery prices in a matrix, with one category listed by row and another by column. A two-way lookup pulls the value where those two labels intersect, which makes this pattern useful for rate cards, schedules, and pricing tables.
In this exercise, you'll use INDEX with two MATCH functions to return the correct shipping rate. One MATCH should find the row for the selected zone, and the other should find the column for the selected weight bracket.
A common pattern looks like this:
=INDEX(data_range, MATCH(row_value, row_labels, 0), MATCH(column_value, column_labels, 0))
Build your formula in B10 using the lookup inputs already provided in the query area. Return the shipping rate at the intersection of the chosen zone and weight bracket.
Need some help?
Hint 1
The INDEX array should include only the shipping rates, not the zone labels in column A or the weight headers in row 1.
Hint 2
Use the lookup inputs in B8 and B9. Match the zone against A2:A6, match the weight bracket against B1:E1, and use those two positions to return the value from B2:E6.