How to look for a value across two tables and return result of which table the result was found in

[GSElo]

Long time reader, first time caller,

I want to look for a value in two tables(columns in sperate worksheets) and have the result come back of which table the value was found in.

I have tried with If and Vlookup, and can return the result of the first table search, but does not work when searching the second table.

=IF(VLOOKUP(I83,Rebuild!I:J,1,FALSE)=I83,"Rebuild",IF(VLOOKUP(I83,Retired!I:J,1,FALSE)=I83,"Retired"))


Any help would much appreciated.

Gary

 

[Fluff]

Will the value of I83 only exist in one of those two sheets?

 

[jasonb75]

If I83 will definitely be in one of the 2 sheets then try

=IF(ISNUMBER(MATCH(I83,Rebuild!I:I,0)),"Rebuild","Retired")

If I83 might not be in either then

=IF(ISNUMBER(MATCH(I83,Rebuild!I:I,0)),"Rebuild",IF(ISNUMBER(MATCH(I83,Retired!I:I,0)),"Retired","No Match"))

 

[GSElo]

Thank you!
I83 might not be there, and the second solution worked perfectly.

Can see that I was quite some way off in my original formula!

Thanks again for the help