Return values in comma separated format when specific text is found in a string

[webarnes99]

I have a list of IDs that I want to put into a single field in a comma separated format based on a condition where specific text is found. I have attached a screenshot of the dataset. I want the mediaIDs to be the coma separated values and I am looking for specific text in the categories column. Any help is very much appreciated.

 

[Cubist]

You can try this for individual formulas. Note the references on Tab 2 need to be locked.

=TEXTJOIN(", ",,(FILTER('Tab2'!$D$3:$D$15,ISNUMBER(SEARCH(A3,'Tab2'!$E$3:$E$15)),"")))