Hello
First post here. Im doing a formula that searches for text in a string via a list
=SUMPRODUCT(--ISNUMBER(SEARCH(anger,C1)))>0
That is my formula. It works fine but returns true or false. Is there a way to return the word it finds in the text? and what about if it finds multiple words?
Any help would bne great
Bookmarks