5

This is the problem I'm seeing:

Error - Unable to parse query string for function QUERY parameter 2: NO_COLUMND

Error - Unable to parse query string for function QUERY parameter 2: NO_COLUMND

The formula is of the form:

=query(importange("...", "Sheet!A:V"), "select D where V = 1", 1)

I imported data from another sheet, I want this current sheet to display column D when Column V is 1.

Is there a different way rather than my current formula?

  • Don't rely on the picture. Not everyone can see it. You'll be better served by including the text of your function in your question. – ale May 20 '16 at 20:04
  • You've misspelled "importrange" in your query. – ale Jul 19 '18 at 12:39
11

When using query with importrange, the imported columns must be referred to as Col1, Col2, Col3, etc, according to their positions in the imported range. So, you should replace

"select D where V = 1" 

with

"select Col4 where Col22 = 1" 

The reason is that imported range is not considered a part of any sheet, so its column names are not like sheet column names.

To find the number of a column without reciting the alphabet, you may want to put =column() in it temporarily.

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.