Solved

vlookup between two worksheets

Posted on 2014-01-28
3
462 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 25

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

The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

Question has a verified solution.

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

In this post we will learn different types of Android Layout and some basics of an Android App.
In this post we will learn how to make Android Gesture Tutorial and give different functionality whenever a user Touch or Scroll android screen.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

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