=IF(ISNA(VLOOKUP(value,table1,2,FALSE)),IF(ISNA(VL OOKUP(value,table2,2,FALSE
)),
IF(ISNA(VLOOKUP(value,table3,2,FALSE)),"Not found",
VLOOKUP(value,table3,2,FALSE)),VLOOKUP(value,table 2,2,FALSE)),VLOOKUP(value,
table1,2,FALSE))

--
HTH

Bob Phillips

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

"Nir" wrote in message
...
Hi
I have a value that can be found in coulmn A of 3 different tables, i
would
like to perform the lookup on the 3 tables. can it be done without
unifying
the tables?

thanks