Solved

vlookup between two worksheets

Posted on 2014-01-28
3
436 Views
Last Modified: 2014-01-28
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
Comment
Question by:Beeyen
3 Comments
 
LVL 23

Accepted Solution

by:
NBVC earned 500 total points
ID: 39816113
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
 
LVL 24

Expert Comment

by:chaau
ID: 39816117
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
 

Author Closing Comment

by:Beeyen
ID: 39816174
To wizard: I do have access 2010
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Multiple Open Excel Spreadsheets 12 43
Excel Question 17 15
Microsoft Office Licensing Question 2 29
Msgbox tickler 13 30
This is about my first experience with programming Arduino.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question