1

I am trying to create a query that pulls information based on two drop downs. The first drop down searches "staff" or "student" in column C of my form response tab, and the second drop down is the "event" in column E of my form response tab. The query I keep trying only produces my headers. Really struggling here. Thanks.

https://docs.google.com/spreadsheets/d/1icO6CI_xM75jH8PSFSMFrWYZqnBLEIEBNZZI-oDAm_s/edit#gid=1326375844

2

1 Answer 1

0

Set the drop-down lists to point to 'RESPONSES' instead of Dates, and use either of these formulas:

=query(RESPONSES!A:N, "where C = '" & A1 & "' and E = """ & B1 & """ ", 1)

=filter(RESPONSES!A2:H, RESPONSES!C2:C = A1, RESPONSES!E2:E = B1)

See the Solution sheet.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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