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,