vlookup – Find a word within a phrase

Click below to download a spreadsheet using the formula:

Copy of FindaWord_WithinPhrase

excel vlookup

 

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