Is VLOOKUP what I need for this?

  • Thread starter Thread starter Eddie A
  • Start date Start date
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
 
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
 
Back
Top