One way ..

Assume the 2 lists are in cols A and B, in row1 down with
col A housing the 4500 names, col B containing the 400 names

Put in C1:
= IF(B1="","",IF(ISNUMBER(MATCH(B1,A:A,0)),ROW(),""))

Put in D1:
=IF(ISERROR(SMALL(C:C,ROWS($A$1:A1))),"",INDEX(B:B,MATCH(SMALL(C:C,ROWS($A$1
:A1)),C:C,0)))

Select C1:D1, copy down to D400

Col D will return all the names in the 400 list in col B which is found
within the 4500 list in col A, neatly bunched at the top, with blank rows
below

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Ed" <Ed@discussions.microsoft.com> wrote in message
news:09A638BD-5E13-4BB7-ACEA-74D2D5FEFA05@microsoft.com...
> I need help comparing 2 lists in excel. Here is my goal; I have one list
with
> 4500 names and one list with 400 names. I would like to find out which of
the
> 400 names is on the 4500 name list. how do I do it? thanks for your help.