Try this:

Using a list of 1,377 names in Col_A with a column heading in A1 and another
list of names in cells G2:G100.

A1: Name
C1: Name

H1: Test
H2: =ISNUMBER(MATCH(A2,$G$2:$G$100,0))

Select cells A1:A1377
DataFilterAdvanced Filter
Check: Copy to another location
List Range: (already selected a1:a1377)
Criteria: (Select $H$1:$H$2)
Copy to: (Select $C$1)
Click the [OK] button

The list of matching names will be copied below Cell C1.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Jill" wrote:

Hi I have two columns of names - Column A 1,377 names, Column G 1,456 names.
Most are duplicates. I want to see the names in another column that are not
duplicates. How do I use VLOOKUP to do this? Or do you have any other
suggestions?