• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 479
  • Last Modified:

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
0
Beeyen
Asked:
Beeyen
1 Solution
 
NBVCCommented:
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

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now