Help with Lookup formula

[Hunter Childress]

Please see the sample data attached.

I am trying to create a formula to lookup which of the example texts does the statement in column E occur based on the data in column A&B.

Thank you for the help!

 

[p45cal]

in cell F4:

=TEXTJOIN(CHAR(10),TRUE,FILTER($A$4:$A$8,ISNUMBER(SEARCH(E4,$B$4:$B$8)),""))

Copy down.

 

[Hunter Childress]

This was perfect. Thank you! I was able to apply bits of this logic to other formulas so I appreciate the help!