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

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

Thanks bob, but Q3 is the result of another look up and calculations so
is definitely not text.
and the amended formula did nothing

Thanks anyway

Andy


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

What is the Q3 formula then, so I can try that, because as I said, the first
worked for me.

--
HTH

Bob Phillips

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

"andyell" wrote in
message ...

Thanks bob, but Q3 is the result of another look up and calculations so
is definitely not text.
and the amended formula did nothing

Thanks anyway

Andy


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