Combining two lookup commands

[FACTOR 21]

I am trying to combine two LOOKUP commands in one cell, with no joy, can anyone enlighten me.

The first is

=VLOOKUP(C330,'Trust Acc'!$A$2:$B$20,2,FALSE)

If the result of this returns 0 the second is

=VLOOKUP(B330,'Jez test'!$A$2:$F$200000,6,False)

I have researched and tried many variances but to no avail.

Thanks in advance

 

[Special-K99]

Maybe

=IF(VLOOKUP(C330,'Trust Acc'!$A$2:$B$20,2,FALSE)=0,VLOOKUP(B330,'Jez test'!$A$2:$F$200000,6,False),0)

 

[FACTOR 21]

Thanks for the quick response.

If the first lookup is true '0' is returned as the result and not the value in column 2, if the first lookup is false the correct result is returned from the second lookup.

 

[Special-K99]

Blimey, I botched that up good and proper, apologies.

Try (untested)
=IF(VLOOKUP(C330,'Trust Acc'!$A$2:$B$20,2,FALSE)<>0,VLOOKUP(C330,'Trust Acc'!$A$2:$B$20,2,FALSE),VLOOKUP(B330,'Jez test'!$A$2:$F$200000,6,False))

 

[FACTOR 21]

That works perfectly, many thanks for your quick response and solution, much appreciated.

Have a great Weekend