0

I have a data validation range (drop down) list. I'm using a query to bring back info from the choice of that drop down.
I would like to then filter the information further with a date range that will by typed in. The two formulas below work separately, but I do not know how to get them into one cell.

Formula 1

=QUERY('Receipt Master List'!B5:N, "SELECT B,D,M,N Where (lower(H) = lower("""&E1&"""))")  

Formula 1

=QUERY('Receipt Master List'!B5:N, "Select B,D,M,N Where B >= DATE """&TEXT(G1,"yyyy-MM-dd")&""" AND B <= DATE """&TEXT(H1,"yyyy-MM-dd")&""" ")

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.