Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Excel 2013 - matching entries on two spreadsheets

Posted on 2015-02-18
3
Medium Priority
?
67 Views
Last Modified: 2015-03-02
I have a name, address, city, state and zip spreadsheet "A" with 10,000 entries.
 I have another spreadsheet "B" with 300 names only.
 I would like to take the names on the "B" spreadsheet  and  indicate them on the larger spreadsheet with an "X" in a separate column. (See graphic)

err
Also, whenever there is a match on Spreadsheet "A", I would like to have that entry on spreadsheet "B" indicated in BOLD and ITALIC.
How can I do this?
I asked a similar question previously but now I need the indication in spreadsheet "B".
earlier question
0
Comment
Question by:brothertruffle880
  • 2
3 Comments
 
LVL 31

Expert Comment

by:gowflow
ID: 40617520
Put this formulas in worksheet A in Col B2 and drag down till last data.
=IF(ISERROR(MATCH(A2,Sheet2!A:A,0)),"","x")

gowlfow
0
 
LVL 14

Assisted Solution

by:Mark Bullock
Mark Bullock earned 1000 total points
ID: 40617536
Use Excel's VLOOKUP function. You can do it in both directions, checking if a value in spreadsheet "B" exists in "A" and vice versa.

Excel's in-app help explains it well. Or if you like video instruction, this Microsoft page has a nice video series.
https://support.office.microsoft.com/en-us/article/VLOOKUP-What-it-is-and-when-to-use-it-5984e27b-4f0d-431e-83b1-7ab062c75493?CorrelationId=dfaaa526-291e-4b91-9430-5a1d7ba27aee&ui=en-US&rs=en-US&ad=US

Then you can use conditional formatting.
0
 
LVL 31

Accepted Solution

by:
gowflow earned 1000 total points
ID: 40617556
ooops forgot to attach the file
gowflow
IsThere.xlsx
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

783 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