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