Need help with Query formula

[zazybang]

I have lots of data one one spreadsheet, the goal is to make a query formula that will search for all the responses a person made based on a cells critera. EX:
Sheet 1

Name:	Response:
X	A
Y	B
X	C
X	D
Y	E
Z	F

<tbody>
</tbody>

Sheet 2

Query Formula	Criteria (name): X
A
C
D

<tbody>
</tbody>

The Query formula searched for all responses made by X on sheet 1 then places them on Sheet 2. How would I make such a formula?

 

[JPARKHURST]

I have lots of data one one spreadsheet, the goal is to make a query formula that will search for all the responses a person made based on a cells critera. EX:
Sheet 1

Name:	Response:
X	A
Y	B
X	C
X	D
Y	E
Z	F

<tbody>
</tbody>

Sheet 2

Query Formula	Criteria (name): X
A
C
D

<tbody>
</tbody>

The Query formula searched for all responses made by X on sheet 1 then places them on Sheet 2. How would I make such a formula?

Is the result you're looking for like this?

Query Formula	Criteria (name): X
A	X
C	X
D	X

<tbody>
</tbody>

or this:

Name	Query Formula
X	A,C,D
Y	B,E
Z	F

<tbody>
</tbody>

 

[zazybang]

Is the result you're looking for like this?

Query Formula	Criteria (name): X
A	X
C	X
D	X

<tbody>
</tbody>

or this:

Name	Query Formula
X	A,C,D
Y	B,E
Z	F

<tbody>
</tbody>

I like both, could by chance send me both formulas?

 

[zazybang]

Is the result you're looking for like this?

Query Formula	Criteria (name): X
A	X
C	X
D	X

<tbody>
</tbody>

Actually, ill just take this one ^ thanks btw!

 

[JPARKHURST]

The first would just be an index/match formula, in the above example, using Query Formula as A1, and the data is on sheet named 'Data', with Name being A1

=index(Data!A:A, match(a2,data!B:B,0))

let me get a few thing sfinished and i will post the other formula, you just need to concatenate, but i need coffee before using that many commas.