Varify a value between two or more sheets

J

Joey

Hi

I'm trying to locate a value (eg. 54321) between sheets in other
workbooks.
It's a bit hard to explain because I would like the result to be
negative or not available so that I can issue the ID to new projects.

In Column A in Sheet 1 and Sheet 2 there are a list of values which
relate to data (names) in Column B of those sheets.

Is it possible to do a search by keying a value in A1 in Sheet 3 and
get a result in A2 in the same sheet.
It should show a corresponding name if one is matched or a word like
"none" if it doesn't find anything.


Thanx in advance all
Joey
 
F

Frank Kabel

Hi
not really sure I got it completely but try in A2
=IF(ISNA(VLOOKUP(A1,'sheet1'A1:B100,2,0)),IF(ISNA(VLOOKUP(A1,'sheet2'A1
:B100,2,0)),"none",VLOOKUP(A1,'sheet2'A1:B100,2,0)),VLOOKUP(A1,'sheet1'
A1:B100,2,0))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula between two workbooks 1
Finding a specific item between two sheets. 2
Complex Match 4
Summing VLookup from a variable number of sheets 4
Linking data from one worksheet to other worksheets using a formul 4
How to list cells from two sheets that has different values in theirneighboring column? 8
Look up & auto populate between sheets 7
copying data from master ti individual sheets 3

Top