This was very helpful although I used these together. I wanted a formula
next to the master list that looked at both sub-lists to see if there was a
match. I ended up using both of these formulas into one formula and if the
answer was 2 then there was a match between the two sub-lists. Thank you for
your help.

"Sam Wilson" wrote:

If you had the first list of names in column A and the second in column C
then put this in B1 and copy down:

=COUNTIF(C:C,A1)

and this is D1 and copy down

=COUNTIF(A:A,C1)

Anywhere the result is not 0 means you have a match.


"samjwoods" wrote:

Hi,
I need to search between two sets of names to cross reference and find any
matches. The data will not have been formulated from elsewhere it will just
be lists of names (either on the same sheet or separate whichever is easier).
Is there a way to do this with Excel?
Thanks for any responses,
Sam Woods