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

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?
 
T

T. Valko

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.
 
Top