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
Bookmarks