IMPORTRANGE returning NO_COLUMN

Question

I am using:

=query(importrange(SHEETID,"Orders!$A$2:$X"),"select Col1 where Col23=0")

in a Google Sheets and receiving the following error:

Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: Col23"

I have authorized the IMPORTRANGE already and it will import that data correctly when used without the query.

Any ideas as to what is causing this error?

Create a demo spreadsheet, share it with anyone with the link and include it on the question. Reference: [mcve]. — Rubén, Nov 11 '16 at 20:38

Ed Nelson · Answer 1 · 2016-11-25T21:15:47.523

0

Remove the ) before the select like this:

=query(importrange("1_WqEDk9_XKakYVdzIm0eahWpBrY4-55ez4gauolMdAo","Sheet1!$A$2:$X","select Col1 where Col23=0")

edited Nov 25 '16 at 21:15

answered Nov 12 '16 at 01:04

Ed Nelson

This looks the same. I don't know what ) you removed. – enano2054 Nov 25 '16 at 21:03

1 Answers1