vlookup between two worksheets

Good Day Experts,

I am wondering if you know an automated way to find out all members in the Spreadsheet1 who are also in the spreadsheet 2
Members-who-Moved-to-with-new-id.xlsx
BeeyenAsked:
Who is Participating?
 
NBVCConnect With a Mentor Commented:
In K2 of Sheet1:

=ISNUMBER(MATCH(E2,Spreadsheet2!F:F,0))

copied down

TRUE means match found.

You can also do it from sheet1:

=ISNUMBER(MATCH(F2,Spreadsheet1!E:E,0))
0
 
chaauCommented:
Do you have MS Access installed on your machine? It is easier to do using a query. If yes, I can show you how to link the spreadsheets to MS Access tables and run a simple query to find the duplicates. After the duplicates found they can be exported to a new spreadsheet
0
 
BeeyenAuthor Commented:
To wizard: I do have access 2010
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.