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

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
brothertruffle880Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Phillip BurtonConnect With a Mentor Director, Practice Manager and Computing ConsultantCommented:
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
 
brothertruffle880Author Commented:
Yes.  Spreadsheet 2 is the smaller spreadsheet.
Yes.  The nams are in column A
0
 
brothertruffle880Author Commented:
PERFECT.  Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.