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?