Return multiple values with multiple conditions

Hi,

I'm in desperate need of this.

I'm have a spreadsheet where I have 50 questions and each question can have a value of 0 thru 4.

QuestionNumbers Value
Question1 0
Question2 1
Question3 1
Question4 2

I need to pull all the values of corresponding cells(QuestionNumbers) which have a value 1.

I would appreciate any help that you could provide.

Thanks
Sushant

Hi,

I think i did not explain the question right:

I have 2 cols:

Question Number VALUE
Question 1 0
Question 2 4
Question 3 1
Question 4 0

The VALUE is not the count, It is an IF function and accordingly it gives values which is depends on the answer of the question.

Now i have 50 questions....

What i wanted to do was that Pull all those questions(Like Vlookup) which have a value 2. For example I want to pull all question numbers which have VALUE 0. Then i would get 2 question numbers...which would be Question 1 and Question 4 according to the above table.

I hope i am a bit more clear this time.

Thanks

This is amazing stuff....i'm trying to understand the formula....

Thanks a lot buddy!!!

Thanks
Sushant

Based off of starguy's data, here is a method to do it without a helper column.