Sheets query using importrange with select where statement referencing sheet cell

Question

How do I correctly reference a cell in a sheet such that a query can use the string in the cell as a filter in the query where statement?

The below query fails in the where statement with:

"Error:Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: BADO".

"BADO" is the string in cell C1 referenced in the where statement and is a valid value in Col2 in the importrange sheet.

The query returns all date if "Col2" is entered into cell C1. I've tried several other variations to no avail.

{=QUERY(importrange("1cCQQA3DYwuiSKokzcuqhnUPVV8-Ok2JAZUzG6ryxLf8","$A$2:$F"),
        "select * where (Col2="&C1&")")}

Below is my test sheet:

https://docs.google.com/spreadsheets/d/1RY2AXali01-N0fd-zBPPJDO-4vPuoRGsG5dSMn1NBJU/edit?usp=sharing

shabnam bharmal · Accepted Answer · 2018-10-17 04:57:14Z

0

The formula is right however the mistake is that in where cluase, Col2 requires a string value but we are passing BADO. ideally the synatx needs to be 'BADO' with single quotes. So just added the single quotes in where clause of the formula.

=QUERY(importrange("1cCQQA3DYwuiSKokzcuqhnUPVV8-Ok2JAZUzG6ryxLf8","$A$2:$F"),"select * 
where Col2='"&$C$1&"'")

Hope this could help.

answered Oct 17, 2018 at 4:57

shabnam bharmal

5845 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sheets query using importrange with select where statement referencing sheet cell

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related