Multiple IF, ARRAYFORMULA, TEXTJOIN Returning FALSE

user_13365230 0
Viewed 35

I'm trying to show sizes available for unique products in one cell. I currently have the following, however, it is returning FALSE in the cells that should be blank.

Returned value: XS,FALSE,FALSE,L,FALSE,FALSE,3XL,FALSE Expected value: XS,L,3XL

=ARRAYFORMULA(TEXTJOIN(",",TRUE,IF($B$2:$B$15>0,IF($A$2:$A$15=A2,$C$2:$C$15,""))))

Example Workbook

Any help is much appreciated!

textjoin google-sheets if-statement arrays
1 Answers

I think your expected results in rows 10-15 are not correct.

Try this formula

=INDEX(TEXTJOIN(",",1, 
   IF(($A$2:$A$15=A2)*($B$2:$B$15>0),$C$2:$C$15,"")))

enter image description here

user_15277800
Related