Index Match: search for a string and return multiple values

[Zexall]

I'm looking to do a lookup, and I assume index match is the rout to go, but I'm not certain. The lookup value will always be a single line, but the column I'm searching for a match on may have multiple lines with a carriage return between them. There may be multiple matches at well. I've attached a small example with what I'm hoping for from the output. I tried using a lookup/search but I wasn't sure how to account for the carriage return. I assume Index/match is where to go next, but I wasn't sure how to handle the multiple matches. Any guidance would be greatly appreciated!

[Bo_Ry]

Please try at E2

=TEXTJOIN(CHAR(10),,IF(ISNUMBER(FIND(D2,$A$2:$A$30)),$B$2:$B$30,""))

[Zexall]

That appears to do the trick! And now I know how to use textjoin to help with this. Thanks much!