Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

IF CONTAINS Formula

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...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    7 years ago

    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", "" )
    )
)
Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

Thanks for your help Ashish.