Hi All
I have for example a cell (A1) that contains the following text....."likelihood of mental illness through emotional abuse"
The keyword for me in the text is "emotional"
I have tried the following logic to pull out the keyword =IF(SEARCH("emotional",A1,1)>0,"Emotional") which works fine.
However, the text will contain EITHER one of the following keywords "Emotional", "Physical" or "Mental", OR any combination of the words.
When I try the following formula I just get a #VALUE! error
=IF(SEARCH("emotional",A1,1)>0,"Emotional",IF(SEARCH("physical",A1,1)>0,"Physical"))
Ideally what I want to do is identify the single Keyword that appears in the string OR if a combination of 2 or more of the Keywords appear output the result of "Multiple"
Any thoughts welcomed, thanks !
Simon
I have for example a cell (A1) that contains the following text....."likelihood of mental illness through emotional abuse"
The keyword for me in the text is "emotional"
I have tried the following logic to pull out the keyword =IF(SEARCH("emotional",A1,1)>0,"Emotional") which works fine.
However, the text will contain EITHER one of the following keywords "Emotional", "Physical" or "Mental", OR any combination of the words.
When I try the following formula I just get a #VALUE! error
=IF(SEARCH("emotional",A1,1)>0,"Emotional",IF(SEARCH("physical",A1,1)>0,"Physical"))
Ideally what I want to do is identify the single Keyword that appears in the string OR if a combination of 2 or more of the Keywords appear output the result of "Multiple"
Any thoughts welcomed, thanks !
Simon