Apart from the fact that the first lookup doesn't have a ,0 parameter at the
end it looks fine. Are you sure that Q3 isn't text, try

=IF(--Q31,VLOOKUP(P3,over_one_box,2,0),VLOOKUP(P3,One_b ox,2,0))


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"andyell" wrote in
message ...

I am trying to calculate the freight costs of a shipment, there are 3
parameters if the consignment is 1 box there is one table
if more than one box there is a second table
if more than 200 Kgs then it is weight by price This is in one c

this is the formulas I have in place
=IF(P3200,P3*0.69,0)
=IF(Q31,VLOOKUP(P3,over_one_box,2),VLOOKUP(P3,One _box,2,0))
P3 = the weight of the consignment
Q3 = the number of boxes

the first formula works fine
the second formula appears only to be searching the over_one_box table

Any ideas why it will not search the two tables?

Andy


--
andyell
------------------------------------------------------------------------
andyell's Profile:
http://www.excelforum.com/member.php...o&userid=35272
View this thread: http://www.excelforum.com/showthread...hreadid=560486