Table summarized

[kelivor]

I have a table that shows all possible answers of a thing, and by different formulas there is a "1" and a "0" when it applies based on different conditions.

Then I want in an another table each row to list whatever has a 1 by it

So table 1 is , for example

A B
1 Apples
0 Oranges
0 Bananas
1 Potatoes
0 Tomatoes
1 Pears

I'd like the row 1 to give apples, the row 2 to gives potatoes, row 3 to give pears.

I was thinking of matching VLOOKUP and OFFSET. I have thought of switching column A and B of first table like VLOOKUP like look for 1s, but I dont know to skip the first result when they found the first one.

Thanks

[martindwilson]

use a helper in say col d =if(a1=1,row(),"") drag down
then
=iferror(INDEX($B$1:$B$100,MATCH(SMALL($d$1:$Ad$100,ROWS($A$1:A1)),$d$1:$d$100,0)),"") drag down

[kelivor]

Work very well.

Thank you.