Retrun value if cell contains certain text

[jwi1]

Hi all,

Hope someone can help me with folowing.

If I have cells in a column, containing the following text: SEAR134A

I want to have a calculated column which give me the folwing outcome:

if the text of a cell in that particular column contains "SEAR", then the outcome must be "REFRIGERANT". If the text in a cell of that particular column does not contain "SEAR", then the outcome must be "OTHER".

Thanks upfront for your kind assistance in this.

John

[amitchandak · Accepted solution]

@jwi1 , Try a new column like

Switch(true(),

search("SEAR", [column],,0) >0, "REFRIGERANT",

"OTHER"

)