searching in more than one table

[andyell]

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(P3>200,P3*0.69,0)
=IF(Q3>1,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

 

[Bob Phillips]

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(--Q3>1,VLOOKUP(P3,over_one_box,2,0),VLOOKUP(P3,One_box,2,0))


--
HTH

Bob Phillips

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

 

[andyell]

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

 

[Bob Phillips]

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)