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