Hi, I Would Like To Estimate The Freight Charge.

Freight Charge = Weight X Zone

(the Zone Is Determined By Entering The Destination Zip Code. For Example, If The Shipping Zip Code Is San Jose 95130, The Zone For Destination Morgan Hill 95037 Will Be 3, Zone For A Little Bit Further Salinas Will Be 5).

The Shipping Zip Code Remains The Same. I Would Like A Template To Calculate The Freight By Just Entering The Destination Zip Code & The Weight.
I Will Have A Worksheet With All The Destination Zip Codes And Their Equivalent Zone Numbers.

Please Help. Thanks !!!!!!!!!!!!!