[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Excel 2013 - Two spreadsheets - I need to match the smaller spreadsheet

Posted on 2015-02-11
3
Medium Priority
?
82 Views
Last Modified: 2015-02-11
I have a name, address, city, state and zip spreadsheet with 10,000 entries.
I have another spreadsheet with 300 names only.
I would like to take the names on the smaller spreadsheet  and  indicate them on the larger spreadsheet with an "X" in a separate column. (See graphic)
How can I do this?
err
0
Comment
Question by:brothertruffle880
[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
  • 2
3 Comments
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 2000 total points
ID: 40603411
I will assume the smaller spreadsheet is called "Spreadsheet 2", and the names are in column A of that column.

In cell B2, use

=if(countif('Spreadsheet 2'!A:A,A2)>0,"X","")
0
 

Author Comment

by:brothertruffle880
ID: 40603449
Yes.  Spreadsheet 2 is the smaller spreadsheet.
Yes.  The nams are in column A
0
 

Author Closing Comment

by:brothertruffle880
ID: 40603507
PERFECT.  Thanks!
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

656 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