Oct 07 2022 01:15 AM
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.
Oct 07 2022 02:09 AM
It could look like this:
=IF(ISNUMBER(SEARCH("some word", cell)), "this value", "that value")