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

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?

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

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.

--
Biff
Microsoft Excel MVP


"Kristin" wrote in message
...
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?

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

I believe this will give you what you want:
http://www.contextures.com/xlFunctions02.html


Regards,
Ryan--


--
RyGuy


"T. Valko" wrote:

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.

--
Biff
Microsoft Excel MVP


"Kristin" wrote in message
...
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?