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