Is there a way to make a =CONCATENATEIFS() in Excel
May I suggest that you use TEXTJOIN.
Assuming your table is on columns A to C, and the lookup values from columns E to G, use the formula:
=TEXTJOIN(",",TRUE,IF($A$2:$A$6=$E10,$B$2:$B$6,""))
DRag the formula down to the other cells.
