I have a list of volunteers in sheet one. They have selected what programs they want to participate in with a yes or no in the column under that program. How can I create a formula that says if this cell says yes take that row of information to another spreadsheet. This was all the people that said yes for that project are on one sheet and easier to find?

Sample data:

        | Breakfast | Lunch | Dinner
Steve   |    yes    |   no  |   yes
Jane    |    yes    |  yes  |   yes
Bob     |     no    |  yes  |   yes
Mary    |     no    |   no  |   yes

On sheet for "Breakfast":

        | Breakfast 
Steve   |    yes    
Jane    |    yes    

On sheet for "Lunch":

        | Lunch
Jane    |  yes
Bob     |  yes


  • Jennifer, I've added some sample data to help illustrate what you're trying to do. If I've got it wrong please fix. – ale Sep 23 '13 at 16:12


=QUERY(data!A2:D;"SELECT A WHERE B='yes'")


=QUERY(data!A2:D;"SELECT A WHERE C='yes'")


=QUERY(data!A2:D;"SELECT A WHERE D='yes'")

Assuming that the Sample data is in data!A:D

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.