Forum Discussion
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 ...
It could look like this:
=IF(ISNUMBER(SEARCH("some word", cell)), "this value", "that value")