Hi Melissa,

I have a workbook that similar.

http://savefile.com/files/2803124

kk


"Melissa" wrote in message
...
I am trying to create a rate schedule for furniture delivery in Excel 2003.
I
would like Excel to automatically fill in the rate if I type in the state
delivered to and the weight of the item. See example below.


We are delivering to three separate zones 1, 2 and 3. For example Zone 1 in
cludes all the midwest states.

The rates for each Zone are determined by weight. Example: Furniture
delivered to Kansas weighing 76 to 150 lbs. is charged a rate of $173.00 and
furniture delivered to Kasas weighing 151 to 250 lbs is charged a rate of
$196.00
--
Thanks for any help you may be able to give,