Formula Help - Return multiple values based on criteria

[Glasgowsmile]

Good day.

I've got the following table and I'm looking for a formula that can find the TRUE values and pull the number above resulting in "2, 4, 9"

I did this formula which works for 2 numbers but I'm thinking there has to be an easier way than typing this out for 9.

=INDEX(I5:Q5,MATCH(TRUE,I6:Q6,))& ", " &INDEX(I5:Q5,MATCH(TRUE,I6:Q6))

1	2	3	4	5	6	7	8	9
FALSE	TRUE	FALSE	TRUE	FALSE	FALSE	FALSE	FALSE	TRUE

 

[Fluff]

How about

=TEXTJOIN(", ",,IF(I6:Q6,I5:Q5,""))

 

[Glasgowsmile]

How about

=TEXTJOIN(", ",,IF(I6:Q6,I5:Q5,""))

Worked perfectly. Can you explain how this works? I'm confused by the IF statement on this one.

 

[Fluff]

The formula is basically saying IF(I6:Q6=TRUE,...)but as your values are either true or false, there is no need to include the =TRUE part