Forum Discussion

Fcin144's avatar
Fcin144
Copper Contributor
Apr 06, 2024
Solved

Identify if multiple values exist in one cell

I am trying to determine if an email address is for a client, or it is not.   So, for example our company email addresses are @nbc.com or abc.com   I would like to know if any incoming email are ...
excel
  • Lorenzo's avatar
    Lorenzo
    Apr 07, 2024

    Fcin144 

     

    in B2:

    =IF( SUM( IFERROR( SEARCH("@", TEXTSPLIT(A2, {"@bnymellon.com","@dreyfus.com"},,,1)), 0) ), "Yes", "No")
Fcin144's avatar
Fcin144
Copper Contributor
Apr 07, 2024
Thank you soooooo much for your patience and expertise, it is truly appreciated. It worked !!!!
Lorenzo's avatar
Lorenzo
Silver Contributor
Apr 08, 2024
Thanks for providing feedback

Resources