Is VLOOKUP what I need for this?

E

Eddie A

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
 
M

Max

Assuming the reference table as posted is in A1:H3
Assume paired inputs will be made in J2:K2 down
Wt inputs in J2 down, eg: 550
Destination inputs in K2 down, eg: BUF
Then in L2, copied down:
=INDEX($B$2:$G$3,MATCH(K2,$A$2:$A$3,0),MATCH(J2,$B$1:$G$1,1))
will return the required cost results, eg: 30.35
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,600 Files:362 Subscribers:60
xdemechanik
 
Top