Suppose you want to run a query against an inline array:

QUERY({"apple"; "orange"; "banana"}, "select A")

This yields Unable to parse query string for Function QUERY parameter 2: NO_COLUMNA.

Is this type of array even addressable?


The columns of an inline array are addressed as Col1, Col2, Col3, and so on.

QUERY({"apple"; "orange"; "banana"}, "select Col1")

The same applies to the arrays imported with importrange, importdata, etc.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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