IF CONTAINS Formula

[Anonymous]

Greetings Everyone. 

I am trying to create a formula in a new calculated column

Basically what I am trying to do is: 

IF (text.in.row contains "ABC", "ABC") OR (text.in.row contains "EFG", "EFG") OR (text.in.row contains "XYZ", "XYZ") 

I did stumble upon this formula: 

CustomColumn = IF(
	ISERROR(
		SEARCH("A", TableName[ColumnName])
	),
	"A",
	"B"
)

Which did work for the first argument, but, the only issue is, it's not letting me do multiple IFs or multiple scenarios. 

Appreciate any help I can get. Doesn't have to be this particular formula, any formula to get me there would help

[jdbuchanan71 · Accepted solution]

Something like this should work for you.

Column =
IF ( CONTAINSSTRING ( Table[Column], "ABC" ),"ABC",
    IF ( CONTAINSSTRING ( Table[Column], "EFG" ),"EFG",
        IF ( CONTAINSSTRING ( Table[Column], "XYZ" ), "XYZ", "" )
    )
)

[Anonymous]

You ... my friend ... are a life saver !!! It worked perfectly. 

[Ashish_Mathur]

Hi,

It will be ideal to create a Table with 2 columns - one listing all your search keywords and another listing all results you want to see when those search keywords are found in your Text column.  Please share your source data (could be dummy data) and this 2 column Table.

[Anonymous]

Thanks for your help Ashish.