Freight Table - weight and zone lookup, return cost

Hi there, I am look for what I think is a simple solution. I need a courier rate returned based on the zone and weight of the shipment. The rate table has 10 zones (B1:K1) and 12 weight classes (A2:A13)

In the sheet "data & result" I want the cost returned in the yellow cells from looking up the weight (D) and zone (C).

Any assistance would be appreciated!

Here, try this in E2:

Formula:

Please Login or Register  to view this content.

Only ground rates must be same. So zone 10 change to zon10 (or you will get #N/A)

thank you very much, you solved my answer. PS i fixed the naming of zone 10. the file provided was fake mock data of my real life tables.