Solved

vlookup between two worksheets

Posted on 2014-01-28
3
414 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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

707 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now