CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulagoogle-sheets-queryimportrange
Luca Fancello
Luca Fancello

Reputation: 53

QUERY with IMPORTRANGE returns "Unable to parse query string ..."

We are currently trying to set up the following formula:

=QUERY(IMPORTRANGE("1uyazplHdGpZeBZWOv3TbnIUfWeHQGyZF5mRsNuWxkO4","Data Salesforce!A:Z"),"Select A Where J = 'Spain'",-1)

The idea is to look for a QUERY with data coming from an IMPORTRANGE.

We get the following error:

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

Any idea how we could resolve it?

Upvotes: 1

Views: 553

Answers (1)

Robin Gertenbach
Robin Gertenbach

Reputation: 10776

Instead of identifying the columns by Alphabetical index you need to reference them by numerical index.

I assume this is because importrange() doesn't really import the range but just the values.
Try 

=QUERY(IMPORTRANGE("1uyazplHdGpZeBZWOv3TbnIUfWeHQGyZF5mRsNuWxkO4","Data Salesforce!A:Z"),"Select Col1 Where Col8 = 'Spain'",-1)

Upvotes: 1

Related Questions