Can you please help me? I am trying to figure out how to do a lookup
with this data.

Track Width 50 75 100 125 150
drop upto 60" 60.01 73.64 98.2 122.72 147.3
drop upto 80" 73.35 87.52 116.7 145.87 175.05
drop upto 100" 83.6 101.37 135.2 168.99 202.8
drop upto 120" 94.85 112.27 149.7 187.12 224.55


Enter Details
*Width*
*Drop*

Price


If you were to add a value into the bold boxes (width and drop) I want
a formula which looks up
the relevant price.
for Example if you were to type 65 in the width box and 72 in drop I
would like C16 to come up with the price in C3.
I'm struggling to work out the function I need.

Many Thanks


--
oldruts
------------------------------------------------------------------------
oldruts's Profile: http://www.excelforum.com/member.php...o&userid=37262
View this thread: http://www.excelforum.com/showthread...hreadid=569787