How to QUERY (ImportRange) if the "where" clause also uses imported values?

Question

743 views Asked by Shop Nicha At 08 January 2017 at 06:12

I am trying to query ImportRange data by the condition that a column matches a value from the imported spreadsheet, but it does not work:

=Query(importRange("KEY1","namesheet1!A2:R1600"), "select Col4 where Col7 = (importRange("KEY1","namesheet2!F108:F108"))  ",0)

There are 1 answers

**Wicket** · Answer 1 · 2017-01-08 07:35:03

Wicket On 08 January 2017 at 07:35

Replace

"select Col4 where Col7 = (importRange("KEY1","namesheet2!F108:F108"))  "

by

"select Col4 where Col7 = " & importRange("KEY1","namesheet2!F108")