Separating multiple values from same sheet in formula

[mystiedx]

Hello!

I'm using the following formula. It may return only one or a number of values from several sheets.

=IFERROR(TEXTJOIN(", ", TRUE, IF('7 BLUE'!D$8:D$47=B$5, '7 BLUE'!$C$8:$C$47&'7 BLUE'!$F$3, "")), "") &
IFERROR(TEXTJOIN(", ", TRUE, IF('7 GREEN'!D$8:D$47=B$5, '7 GREEN'!$C$8:$C$47&'7 GREEN'!$F$3, "")), "") &
IFERROR(TEXTJOIN(", ", TRUE, IF('7 RED'!D$8:D$47=B$5, '7 RED'!$C$8:$C$47&'7 RED'!$F$3, "")), "") &
IFERROR(TEXTJOIN(", ", TRUE, IF('7 YELLOW'!D$8:D$47=B$5, '7 YELLOW'!$C$8:$C$47&'7 YELLOW'!$F$3, "")), "")

The formula works fine if all the values it returns are from separate sheets. However, if there are more than one value from the same sheet, it does not include the comma. How can I correct this?

 

[DanteAmor]

Try:

=TEXTJOIN(", ", TRUE,
IF('7 BLUE'!D$8:D$47=B$5, '7 BLUE'!$C$8:$C$47&'7 BLUE'!$F$3, ""),
IF('7 GREEN'!D$8:D$47=B$5, '7 GREEN'!$C$8:$C$47&'7 GREEN'!$F$3, ""),
IF('7 RED'!D$8:D$47=B$5, '7 RED'!$C$8:$C$47&'7 RED'!$F$3, ""),
IF('7 YELLOW'!D$8:D$47=B$5, '7 YELLOW'!$C$8:$C$47&'7 YELLOW'!$F$3, ""))

 

[mystiedx]

Try:

=TEXTJOIN(", ", TRUE,
IF('7 BLUE'!D$8:D$47=B$5, '7 BLUE'!$C$8:$C$47&'7 BLUE'!$F$3, ""),
IF('7 GREEN'!D$8:D$47=B$5, '7 GREEN'!$C$8:$C$47&'7 GREEN'!$F$3, ""),
IF('7 RED'!D$8:D$47=B$5, '7 RED'!$C$8:$C$47&'7 RED'!$F$3, ""),
IF('7 YELLOW'!D$8:D$47=B$5, '7 YELLOW'!$C$8:$C$47&'7 YELLOW'!$F$3, ""))

Works perfect! Thanks loads.