CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulaformula
Clo Blue
Clo Blue

Reputation: 21

IMPORTRANGE with filter

I want to do an IMPORTRANGE with a filter, where it only pulls through data if a cell in column C contains a term that is listed in another column G.

I need columns A:E to import from another sheet, if the column C data appears in column G somewhere, on the current sheet.

This is what I have done which isn't correct but can't work it out:

=QUERY(IMPORTRANGE("URL","Sheet1!A2:E"),"select * where $C='$G:$G'")

Please see the image below:

enter image description here

Upvotes: 1

Views: 2372

Answers (1)

player0
player0

Reputation: 1

use:

=QUERY(IMPORTRANGE("URL", "Sheet1!A2:E"),
 "where Col3 matches '"&TEXTJOIN("|", 1, G:G)&"'")

Upvotes: 2

Related Questions