I'm trying to search for specific text in a row and output a certain text if it is found. Like searching for a match but a "contains text" match instead of a total match.
I tried using "=IF(SUMPRODUCT(ISNUMBER(SEARCH("dog",A:A,))),"found,""notfound")"
Any suggestions?
Bookmarks