Query and Importrange function with conditions

Question

I'm trying to retrieve data from a google sheet (source) based on specific values (the location) in a column into another sheet (target location). I have tried the query and importrange formulas but I keep getting error messages.

Link to source sheet: https://docs.google.com/spreadsheets/d/1w3LQwmxWrzPAQIsgDhJycJxKdpQxj0gcxo7blBbD1Xc/edit#gid=0

Link to target sheet: https://docs.google.com/spreadsheets/d/1WXQuB3z6h8pjUVKELNZvMkJaqvR5CCj3J14AJSict0s/edit#gid=0

I'd like this formula to filter values based on col7.

Anyone has an idea how to go about it?

I appreciate your help!

I tried this formula: =(QUERY(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1w3LQwmxWrzPAQIsgDhJycJxKdpQxj0gcxo7blBbD1Xc/edit#gid=0","Sample!A2:G"),"select * where Col7 = Midwest"))

And I get this: #VALUE! (Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: Midwest

Martín · Accepted Answer · 2024-04-01 16:04:19Z

0

Two things: try adding simple quotes before and after Midwest, and if that still doesn't work also do an Import range outside of the query to check if your target sheet has the access permissions of the source sheet

answered Apr 1, 2024 at 16:04

Martín

10.4k2 gold badges7 silver badges16 bronze badges

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

1 Comment

SuperJiga Over a year ago

Thanks! @Martin. It worked when I added simple quotes

Collectives™ on Stack Overflow

Query and Importrange function with conditions

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related