Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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


share|improve this question
Jennifer, I've added some sample data to help illustrate what you're trying to do. If I've got it wrong please fix. – Al E. Sep 23 '13 at 16:12
Do you want the info to be moved physically from one sheet to another? – Jacob Jan Tuinstra Oct 17 '13 at 14:23


=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

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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