Hi, I really hope someone out there can help me, I am trying to create a
formual
that will allow me to calculate freight charges. I want to be able to input a
weight and a zone and have it come back with the cost. This is basically
what the sheet looks like now,
Sheet 1 Cell C27 (Weight) 5
Sheet 1 Cell C29 (Zone) 51
Sheet 1 Cell C31-Formula
Now based on my data on sheet two using 5lbs and zone 51 should
make the answer $13.31. The weights from 1 to 50 are in Column A2:A51
on sheet 2 and the Zones are B1:D:1 and the charges are in Columns
B2:B51, C2:C51,D2:D51,E2:E51. None of the formulas I have tried work.
Can anyone out there help me with giving me the exact formula
I should use based on the information I gave to make this work

I appreciate any and all help you can give me.

Thanks alot
--
Kim