Because you just give 1 example so I work from that :
=IF(A1<>"",INDEX(Sheet1!B:B,MATCH("*" & SUBSTITUTE(SUBSTITUTE(A1," ",""),",","") & "*",Sheet1!A:A,0),0),"")
Note : I don't know the standard format you have, may be this only work on that sample too.