Jim55
0
I am struggling with my query. It is only showing my header rows. I would like the choice of “staff” or “student” match column C on Responses tab and then the “1.) 11/3/2022 for Boy’s Basketball” match Column E on Response tab. When those two conditions are selected I want to see just the data matching staff and that event. I’m at a loss of how to get this to work.
https://docs.google.com/spreadsheets/d/1icO6CI_xM75jH8PSFSMFrWYZqnBLEIEBNZZI-oDAm_s/edit
Your formula attempt is:
=query('Form Responses 3'!1:103,"SELECT D,F WHERE C = '"&A1&"' and F = '"&B1&"'")
That fails because your search keys include an apostrophe '.
The easiest solution is probably to express the same through filter(), like this:
=filter(
{ 'Form Responses 3'!D2:D, 'Form Responses 3'!F2:F },
'Form Responses 3'!C2:C = A1,
'Form Responses 3'!F2:F = B1
)
See your sample spreadsheet.