Import from another sheet using QUERY IMPORTRANGE but query where is from current sheet

Question

I'm using query and import range to get from another sheet. Example

=query(IMPORTRANGE("KEY","Form Responses 1!A:L"), "select * where J = '2020-02-01' ")

I want the where part of the query to be driven from a cell on the current sheet, which contains a date. Something like

=query(IMPORTRANGE("KEY","Form Responses 1!A:L"), "select * where J = A1")

How can I use the value from a cell in the current sheet to drive the import query where?

RemcoE33 · Accepted Answer · 2020-05-04 15:37:40Z

1

You can use it on cell reference. You have to set the a1 notaion between: '"& A1 &"'

answered May 4, 2020 at 15:37

RemcoE33

1,6111 gold badge7 silver badges13 bronze badges

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

Comments

player0 · Accepted Answer · 2020-05-04 16:05:14Z

1

try:

=QUERY(IMPORTRANGE("KEY", "Form Responses 1!A:L"), "where Col10 = "&DATEVALUE(A1))

answered May 4, 2020 at 16:05

player0

131k14 gold badges91 silver badges149 bronze badges