Return matching rows from Google Sheets matrix

Question

Given a worksheet with rows and columns, and boolean values in the body, I want to return a list of rows where the values are true for a specific column.

e.g.

Vehicle/Colour	Green	Blue	Red
Sport	True	False	True
SUV	True	True	False
Sedan	False	False	True

I want to return a list of all vehicles that come in Red.

I've created the sheets and started to try some operations using lookup() and vlookup() but got stuck when it became obvious what I was trying wasn't going to work.

Answer 1

You may try:

=filter(A2:A,filter(B2:D,B1:D1="Red"))