Google Sheets query cell reference

Question

I'm trying to have my query reference a cell, but I keep getting errors:

=query(Sheet1!A3:X2838,"Select I, H, Q, P, J, N, O, S Where (N>10) and (J>"""&K2&""") Order By Q Desc Limit 80")

Rubén · Accepted Answer · 2020-06-05 22:25:00Z

0

Replace

J>"""&K2&"""

by

J>"&K2&"

The above because QUERY doesn't require a delimiter for numbers

The spreadsheet doesn't include the formula referred in the question.

It contains =query(Sheet1!A3:X2838,B2) where the content of B2 is not a formula.

Replace the content of B2 by

="Select I, H, Q, P, J, N, O, S Where (N>10) and (J>"&K2&") Order By Q Desc Limit 80"

answered Jun 5 '20 at 22:11

Rubén♦

37.5k11 gold badges72 silver badges234 bronze badges

Your spreadsheet is not using the formula included in the question, if you will use B2 as the second argument of QUERY, you should make it's content a formula – Rubén♦ Jun 5 '20 at 22:21
I works now thanks so much! but if I wanted to use B2 , how would i make B2's content a formula? – daniel chang Jun 5 '20 at 22:23
See the most recent edit to my answer – Rubén♦ Jun 5 '20 at 22:25
1

Thanks, youre the best! – daniel chang Jun 5 '20 at 22:26

Add a comment |

1 Answer 1