Excel lookup function to look for multi word cell for multi result

If you have EXCEL-365 then give a try on below formula.

=TEXTJOIN(", ",TRUE,XLOOKUP("*"&FILTERXML("<t><s>"&SUBSTITUTE(A14,",","</s><s>")&"</s></t>","//s")&"*",A2:A9,B2:B9,,2))