Forum Discussion
Gopalrawat
Oct 07, 2022Copper Contributor
Searching a Character or Word, and put another word if matches.
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")