Two-Way Matrix Lookup with INDEX and MATCH

Question

You have a regional shipping rate matrix in `B2:F10`. Rows in Column A represent Weight Categories (e.g. '0-5kg', '5-10kg'), while Columns B through F represent Zones ('Zone 1' through 'Zone 5'). Given a target Weight in `H2` and a target Zone in `H3`, write a formula in `H4` to return the intersecting rate.

Accepted Answer

Optimal Solution:
=INDEX($B$2:$F$10, MATCH(H2, $A$2:$A$10, 0), MATCH(H3, $B$1:$F$1, 0))

Technical Explanation:
The formula uses INDEX on the 2D matrix ($B$2:$F$10). The row coordinate is resolved by the first MATCH(H2, $A$2:$A$10, 0), and the column coordinate is dynamically found by the second MATCH(H3, $B$1:$F$1, 0).

Weight	Zone 1	Zone 2	Zone 3	Zone 4	Zone 5
0-5kg	15	22	30	38	45
5-10kg	25	38	52	60	68
10-20kg	45	65	85	95	105

	A	B	C	D	E	F	H
1	Weight	Zone 1	Zone 2	Zone 3	Zone 4	Zone 5
2	0-5kg	15	22	30	38	45	5-10kg
3	5-10kg	25	38	52	60	68	Zone 2
4	10-20kg	45	65	85	95	105	Target [Enter Formula]
5
6
7
8
9
10