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