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.
>Solution :
You may try:
=filter(A2:A,filter(B2:D,B1:D1="Red"))
