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

Question

I am trying to use the Google Sheets QUERY function, and I have two sheets, and am trying to query a range in one sheet using a value from another sheet.

Here is the query:

=query(EntireLI, "Select * where D is not null and D CONTAINS "&C43&"", false)

I also tried LIKE instead of CONTAINS.

The error I am getting is:

Error: Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: 
       Discord

When I change "&C43&" to 'Discord', then the function works, but I want it to grab this value dynamically, rather than hardcoding it.

I do not understand why it is using the value of the cell as the name of the column.

The broken query:

The sheet I am querying:

player0 · Accepted Answer · 2022-05-22 23:42:16Z

0

use:

=QUERY(EntireLI, "where D is not null and D contains '"&C43&"'", 0)

answered May 22, 2022 at 23:42

player0

131k14 gold badges91 silver badges149 bronze badges

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

Collectives™ on Stack Overflow

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

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