"Alert" only if 'not contained in'

  • Thread starter Thread starter Steve
  • Start date Start date
S

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
 
Try one of these:

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

=IF(ISNUMBER(SEARCH(A2,B2)),"","Alert")
 
Perfect. Thanks much. Both worked great.

Steve

T. Valko said:
Try one of these:

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

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

--
Biff
Microsoft Excel MVP





.
Click to expand...
 
Back
Top