I am trying to check if each cell in a column (Column D) contains a keyword, found in Column F. There is an associated name (Column B) next to each entry in Column D. I want to search for each keyword in Column D and return the Column B name if the keyword is contained in D.
From Google searching, I have this formula so far: =IFERROR(LOOKUP(1E+100,SEARCH(F1,D3:D9),B3:B9),""). However, it will only return the name associated with the last match in D. I would like to output a list of names if multiple cells in D have a match to that specific keyword.
I am not worried about looping through Column F for each keyword -- I want to paste the formula next to each keyword in F so that it is obvious which names are associated with which keywords.
Any help would be appreciated!
Bookmarks