Hello, I need help making a formula that looks for specific text with sentence and categorizes the sentence. I was able to do this with the =IF(ISNUMBER(SEARCH but it needs to run more than one test for different answers.
Basically, I need to put sentences into certain pools by searching specific text within the sentence. Can I get help?
Solved by A. H. in 19 mins