I'm still not sure I understand...

My subtotal is in E36 and based upon what number shows up in E36 I need it
to pull the number out of column J (J22 - J36)

The shipping table is set up like this:


Columns:
G H I J
$0.00 - $10.00 $3.00
$10.01 - $20.00 $4.00
$20.01 - $30.00 $5.00
$30.01 - $50.00 $6.00
$50.01 - $75.00 $8.00
$75.01 - $100.00 $10.00
$100.01 - $150.00 $14.00
$150.01 - $200.00 $18.00
$200.01 - $250.00 $22.00
$250.01 - $300.00 $26.00
$300.01 - $350.00 $30.00
$350.01 - $400.00 $34.00
$400.01 - $450.00 $38.00
$500.01 - $550.00 $42.00
$550.01 - $600.00 $50.00

(Add $4 for each add'l $50)
(Add $1.50 for handling for each picture) (Note: Pictures start with an item
code of PF or CF followed by a set of numbers)


"Dav" wrote:


why not try vlookup witht the first column being the minimum value in
each category and the second column being the shipping amount

The values need sorting asending

0 3
10.01 4
20.01 5

if the above is a range a1:b3 and the value you want ot look up is in
c4

vlookup(c4,a1:b3)

regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=539845