Searching a Character or Word, and put another word if matches.

Regular Visitor

Hi Folks, I require a formula of function on which I want to search/find a word from a cell and mention a specific value/keyword if the word matches. And if not match, there is another value/keyword to put. 

I tried with a combination of if and search but maybe something missing, so I am not getting the expected output.

1 Reply


It could look like this:

=IF(ISNUMBER(SEARCH("some word", cell)), "this value", "that value")