View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eddie A[_2_] Eddie A[_2_] is offline
external usenet poster
 
Posts: 1
Default Is VLOOKUP what I need for this?

100 500 1000 3000 5000 7500 MIN
BUF 31.21 30.35 29.12 27.89 26.33 24.78 34.39
DTW 30.67 30.07 28.84 27.6 26.08 24.52 34.39

how can I retrieve the proper cost in this sheet. Top row is the price
break in pounds. Left column is the destination; "BUF" is Buffalo, NY "DTW"
is Detroit.
For example if I am shipping between 500 and 999 lbs. my cost per hundred
pounds is 30.35 to "BUF". I need a formula that will detirmine this, after I
select or enter the weight and destination in another cell, then calculate
the total. I am totally at your mercy and need some urgent help.
Thanks to any brave pros' that may have the answer and reply to me.

EddieA