Comparing Cell Contents

[E. J.]

I'm trying to compare contents of one cell, to see if
the name exists anywhere in another column. By using...
=OR(EXACT(A2,D)), the result is False. Unless, the name
exists in the same row, but different column. Am I missing
something somewhere?

Thanks,
E. J.

 

[Jason Morin]

=COUNTIF(D,"*"&A2&"*")>0

HTH
Jason
Atlanta, GA