hello,
please see attached spreadsheet, what i would like for it to do is
search column a for any word/phrase that contains "dog", if it does display number next to , i.e. the one in column b, if when searching for "dog" or any variation where "dog" isnt contained in phrase, display a blank
desired result is in column f and column g.
thanks
Bookmarks