Comparing two lists

[Jennifer Brooke]

I have 2 lists of names and I need to compare to see which
names from List #1 appear in List #2. Could someone tell
me how to do this?

With Much Appreciation,
Brooke

 

[Gerry Kuta]

=IF(ISNA(MATCH(A1,$B$1:$B$1,0)),"Not Found","Found")