Pull some words from a sentences in a range basis some keywords list

[msharma864512]

I want to pull certain keywords from a sentence basis some list of keywords.

For e.g. Cell A3 has a sentence: "Sumit has consulting experience". Cell B3 should return Consulting. Similarly in other rows there would be different sentences with different keywords, and separate sheet would have list of keywords which I would want to return from column A.

Details are in the attachment.

Manish

 

[p45cal]

See attached formula in cell B3:

=TEXTJOIN(", ",TRUE,FILTER(Keywords[Keyword],NOT(ISERR(SEARCH(Keywords[Keyword],A3))),"None"))

Your keywords list has been made into a proper Excel Table.