=QUERY({"key", "val"; "a", 2; "b", 3; "c", 1; "a", 2}, "SELECT * WHERE A = 'a'")

This gives the NO_COLUMN: A error. Is there a way to make it work? The data in my real world sheet comes from a custom function so it can't be a range of cells.

1 Answer 1


QUERY calls to virtual arrays use Colx notation, e.g.:

=QUERY({"key", "val"; "a", 2; "b", 3; "c", 1; "a", 2}, "SELECT * WHERE Col1 = 'a'")

  • Perfect, thanks! Couldn't find that info anywhere.
    – Ivannnnn
    Mar 9, 2021 at 10:24
  • Glad I was able to provide it. And because you've taken the step of marking the solution as "Best Answers," future visitors to the site will be able to find it more easily.
    – Erik Tyler
    Mar 9, 2021 at 10:53

Your Answer

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

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