0

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")

1 Answer 1

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"
4
  • 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 Jun 5, 2020 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? Jun 5, 2020 at 22:23
  • See the most recent edit to my answer Jun 5, 2020 at 22:25
  • 1
    Thanks, youre the best! Jun 5, 2020 at 22:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.