Put this in C1:

=IF(ISNA(MATCH(B1,A:A,0)),"",B1)

and copy down for as many names as you have in column B.

Hope this helps.

Pete

On Aug 8, 12:14*am, Cheimbig
wrote:
In excel, if you have Column A that has a list of names – in Column B you
have another list of names and in Column C you want to show any from A and B
that match – do you know the formula to do this?

I found one that shows me the number of matches, but I actually want to see
the actual names that match.

Suggestions? Thanks in advance
--
Carla Heimbigner