I have some key words i want to search for in a text string using a comma delimitated list. Is there a good way to do this? I've been using a function like this, =IF(ISNUMBER(SEARCH(substring,text)), "Yes", "No")
I'd like to replace the substring with the comma delimited list.
I've uploaded an example sheet that shows what result I'm looking for.
Thanks for the help!
Bookmarks