=IF(ISNA(vlookup1),IF(ISNA(vlookup2),"",vlookup2), vlookup1)

--
HTH

Bob Phillips

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

"Margherita" wrote in message
...
Hi

I'm trying to do a VLOOKUP from two different sheets on a another
workbook.
Can a person combine say for instance a logical function like OR together
with VLOOKUP?

E.g.

=OR(VLOOKUP(lookup_value,'[Register.xls]A3'!table_array,col_index_num,FALSE,
VLOOKUP(lookup_value,'[Register.xls]K'!table_array,col_index_num,FALSE))

I've tried this, but it doesn't seem to work. I'm not sure what other
functions one could try to achieve this.