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.
1 Answer
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.
=FILTER(RESPONSES!A:N,(TRIM(RESPONSES!C:C)=TRIM(A1)), (TRIM(RESPONSES!E:E)=TRIM(B1)))
, why not?