I am looking to merge both query formulas together but am having problems. The first query is returning results based on two text criteria from a drop-down list (C1 and C2) and the second is the date range (F1 and F2). Both queries work separately. I want to have one query that will pull the criteria in C1 and C2 based on the date range in F1 and F2.
I have tried an array formula but keep getting an error. Any help or suggestions would be appreciated.
Text Criteria Query:
=QUERY(Sheet1!A1:BL, "select A, E, X, S, V, T, AU, AC where A= """&C1&""" AND AC= """&C2&"""")
Date Range Query:
=QUERY(Sheet1!A1:BL, "select A, E, X, S, V, T, AU, AC where E >= DATE """&TEXT(F1,"yyyy-MM-dd")&""" AND E <= DATE"""&TEXT(F2,"yyyy-MM-dd")&""" ")