CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
vivekh
vivekh

Reputation: 15

multiple where clause value form different sheet

I am trying to run this query using 2 where clause with the value coming from a different sheet, which is giving an error

These work

=query(Expenses!A1:H, "select B,D,G,H where G=2023 and H="& VALUE(Data!D2))
=query(Expenses!A1:H, "select B,D,G,H where H="& VALUE(Data!D2))

This one does not and gives an error. What am I missing here

    =query(Expenses!A1:H, "select B,D,G,H where G="& VALUE(Data!D1)" and H="& VALUE(Data!D2))

Thank you.

Upvotes: 0

Views: 37

Answers (1)

rockinfreakshow
rockinfreakshow

Reputation: 30289

use:

=query(Expenses!A1:H, "select B,D,G,H where G="& VALUE(Data!D1)&" and H="& VALUE(Data!D2))

Upvotes: 2

Related Questions