QUERY returns parsing error

Question

My query is not working but I can’t find the problem.

=query(Sheet1!A1:AC; "select * WHERE
   H>="&E11&" And I>="&A14&" And J>="&B14&)

It always says that there is a parsing problem, but I can’t find it. I‘d really appreciate any help with finding the mistake.

In such case, you should provide more details, like the spreadsheet locale / country, add sample values for the referred ranges and the expected result. — Rubén - Volunteer Moderator -, Commented May 2 at 15:38

Blindspots · Accepted Answer · 2024-05-02 18:01:59Z

0

Per @Rubén you have a trailing ampersand operator &

Your formula should be

=QUERY(Sheet1!A1:AC; "WHERE H>="& E11 
   &" AND I>="& A14 &" AND J>="& B14)

If you are in North America, the semi-colon ; should also be changed to a comma ,:

=QUERY(Sheet1!A1:AC, "WHERE H>="& E11 
   &" AND I>="& A14 &" AND J>="& B14)

edited May 2 at 18:01

answered May 2 at 13:50

Blindspots♦

7,1205 gold badges19 silver badges38 bronze badges

Add a comment |

1 Answer 1