current community

your communities

more stack exchange communities

company blog
Stack Exchange Inbox Reputation and Badges
tour help
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top
up vote 2 down vote favorite
1

This is the problem I'm getting:

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)

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

I imported data from another sheet, I want this current sheet display column D when Column V is "1". Is there a different way then my current formula?

share|improve this question
    
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. – Al E. May 20 at 20:04
up vote 3 down vote accepted

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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