"Alert" only if 'not contained in'

[Steve]

I have 2 separate name data downloads.
One in column A, the other in Column B
A B C
Smith Smith, Alex IF(A2=B2,"", "ALERT")

I really only need C to produce the alert if a different name is in A, and
therefore want the above sample to result in ""
Can a/the formula show in C something like...
If all of A is contained in B, then "", "Alert").
Thanks,

Steve

 

[T. Valko]

Try one of these:

=IF(COUNTIF(B2,"*"&A2&"*"),"","Alert")

=IF(ISNUMBER(SEARCH(A2,B2)),"","Alert")

 

[Steve]

Perfect. Thanks much. Both worked great.

Steve

Try one of these:

=IF(COUNTIF(B2,"*"&A2&"*"),"","Alert")

=IF(ISNUMBER(SEARCH(A2,B2)),"","Alert")

--
Biff
Microsoft Excel MVP





.

 

[T. Valko]

You're welcome. Thanks for the feedback!