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?
Bookmarks