Formula to Calculate by Zones and get the higher value

[Junruner]

Hello:

This is my first post here. Thanks in advance for the help.

Here is my situation. I have a trucking company and we delivery by zones (Towns) each zones have a delivery charge either by weight or cft. (Cubic Feet) whichever is greater not exceeding a maximum and also has a minimum. Here is an example. I Have 10 zones they all change.

POINT ZONE CFT CWT
BAYAMON 1 MIN CHARGE $25.00 $25.00
CATANO 1 1 TO 2,999 $0.22 $2.57
GUAYNABO 1 3000 TO 5999 $0.22 $2.27
HATO TEJAS 1 6000 AND OVER $0.22 $2.06
LEVITTOWN 1 MAX CHARGE $150.00 $150.00
PUERTA DE TIERRA 1
PUERTO NUEVO 1
TOA ALTA 1
TOA BAJA 1

I have tried =LOOKUP
also tried =IF

No luck. Any help is greatly appreciated.

[Jacc]

If you post a workbook with some sample data it will be a lot easier to help you.