Searching for non specific text and returning multiple values

I was wondering if it was possible to search for some text in an array and then return all the values in another column where that text appears.

A sample workbook has been attached

Thanks in advance