How do I find multiple text in diff cells in another worksheet?

  • Thread starter Thread starter Kristin
  • Start date Start date
K

Kristin

I am trying to take an Excel Spreadsheet that contains the names of all of my
customers and search a seperate spreadsheet that contains many customer names
to see if any of the names on my list appear in that list. Is there a way to
do this?
 
One way...

Assume one list is on sheet1 starting in cell A1. The other list is on
sheet2 starting in cell A1.

We'll compare sheet1 list to sheet2 list.

Enter this formula in sheet1 cell B1:

=IF(COUNTIF(Sheet2!A:A,A1),"Yes","No")

Copy down as needed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function in Excel to count and list number of entries of text valuesin a row. 2
how to fill in names in cells automatically 2
Adding multiple numbers in one cell 16
How do I auto complete a cell with text from another worksheet? 3
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
Excel Typed text appears in wrong cell 0
matching & combining data from seperate worksheets 2
How to get range names to Apply across multiple tabs 1

Back
Top