Click below to download a spreadsheet using the formula:

Copy of FindaWord_WithinPhrase

 

=LOOKUP(2^15,SEARCH(D$2:D$5,A2),D$2:D$5)