spreadsheet - Google Sheets : QUERY using cell contents as SQL variables

#spreadsheet - #Google_Sheets: #QUERY using cell contents as SQL variables - Stack Overflow
▻http://stackoverflow.com/questions/26448028/google-sheets-query-using-cell-contents-as-sql-variables
▻http://cdn.sstatic.net/stackoverflow/img/apple-touch-icon@2.png?v=73d79a89bded&a

nstead of fixed strings such as ’ENQ’, you can have your formula refer to the index in column A of your output. For example, you could change your formula to this, in cell C4:

`
=QUERY($A$24:$D, “Select D Where B=’” & $A4 & “’ and A=’2/27/14 - Thu’”)
^^^^^^^

`