Forum Discussion
Solved
How to Return Multiple Results as Comma Seperated Values
What formula(s) should I use instead of INDEX and MATCH to return multiple values? In the attached example, I would like Column B to list multiple results as a comma-separated list. Using row 2 as an...
In B2:
=TEXTJOIN(", ", TRUE, FILTER($C$1:$L$1, C2:L2="Yes", ""))
or
=TEXTJOIN(", ", TRUE, IF(C2:L2="Yes", $C$1:$L$1, ""))
In B2:
=TEXTJOIN(", ", TRUE, FILTER($C$1:$L$1, C2:L2="Yes", ""))
or
=TEXTJOIN(", ", TRUE, IF(C2:L2="Yes", $C$1:$L$1, ""))