Google Sheets | Reference in Quotation Marks

Hi All,

I am trying to use a cell reference within a quotation marks but it returns nothing.

My formula is =QUERY(Monthly_Merged1!W1:AA,"select * where W = 2")

The 2 in the formula refers to the month number of the previous month. That's why, I use the following formula to return "2" in a cell (G1): =text(MONTH(EOMONTH(TODAY(),-2)+1),"0")

When I re-write my formula, it becomes =QUERY(Monthly_Merged1!W1:AA,"select * where W = """&G1&"""") but this returns nothing, a screenshot in the attachment.

Is there any suggestion how I can fix this?

You don't need so many double quotations.. just enough to open and close and include things inside the SQL query instruction.

So, your formula should be:

Please Login or Register  to view this content.

The Query formula to be used can be more simplified to;

Please Login or Register  to view this content.

and, the formula in G1;

Please Login or Register  to view this content.

BTW;

Without using the formula in G1, these 2 formulas can be inserted in the Query formula as;

Please Login or Register  to view this content.