Find text annd exclude certain strings

[tomgag]

Hi, I want to find the string withing my column and exlude if certain strings are present. I use the following code:

Lookup= IF (ISBLANK ( SEARCH ( "Ronaldo", Table[Column], 1, BLANK () ) ),
"",
"Ronaldo"
)

It gives me Ronaldo or NULL values but I want to exclude when Messi or/and Pogba are present in the string Table[Column].

[v-jiascu-msft]

Hi @tomgag,

Could you please mark the proper answers as solutions?

Best Regards,

Dale

[tomgag · Accepted solution]

Solution is:

Ball = IF (NOT(ISBLANK ( SEARCH ( "Messi", 'Table'[Column], 1, BLANK () ) ))

&& ISBLANK ( SEARCH ( "Ronaldo", 'Table'[Column], 1, BLANK () ) )

&& ISBLANK ( SEARCH ( "Pogba", 'Table'[Column], 1, BLANK () ) ), 1, 0)

[parry2k]

you can add the add and or condition to your if statement (for and use && and for or use ||)

If you explain what is your logic, will get you the expression.