CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
Cuppy
Cuppy

Reputation: 113

QUERY Function Question Regarding WHERE clause

I have a query where I am trying to match the range value with the value that is in the first column (A) of the current row:

=QUERY(IMPORTRANGE("https://URL.com", Spreadsheet!A:Z), "SELECT COl4 WHERE Col1 = "' & CONCATENATE('A', ROW()) & '")

So essentially, I am trying to select the value of col4 if col1 matches the value of "A235" or A + whatever the current row is.

However the Concatenate part doesn't seem to be working (Formula parse error) and if someone could point me in the right direction, it will be awesome.

Thanks!

Upvotes: 0

Views: 73

Answers (1)

kishkin
kishkin

Reputation: 5325

Repeating a working solution from my comment.

Try this:

=QUERY(IMPORTRANGE("https://URL.com", Spreadsheet!A:Z), "SELECT COl4 WHERE Col1 = '" & A:A & "'")

Upvotes: 1

Related Questions