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")
SophieT's avatar
SophieT
Copper Contributor
Apr 07, 2024
Is the data in column A actual data? as in a value or is it a formula to populate the cell? if its not a value you will find it hard to get a formula to recognize the data - unless you put value at the front. eg. if(value(or(countif(a3,{"*nbc*","*abc*"})),"No","Yes")
Fcin144's avatar
Fcin144
Copper Contributor
Apr 07, 2024
For Column A, it actual data, it is a value. It is not a formula.

Resources