Textjoin, Concat a list of emails if they are in a specific Group.

In my Workbook are two sheets, A and B. In Sheet A are in each row the Names and email Addresses and group names. For example, I want all the email Addresses for Group Apple in Sheet B, textjoined and separated by Comma.

If in Sheet B the group name matches the group name in Sheet A, take the email address and concatenate it into one string and put it in Column C of sheet B.

I used this formula

=IF(MATCH(B2;A!E2:E26);TEXTJOIN(", ";TRUE;A!F2:F26);" ")

but the string of email addresses does not stop when the group name does not match anymore.

I appended an sample Workbook.