IMPORTRANGE with filter

Question

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:

To make things easier for the community, can you please provide a link of the sample of your sheet or a copy that can be used for testing? — Ricardo Jose Velasquez Cruz
– Ricardo Jose Velasquez Cruz, Commented May 18, 2022 at 20:22

player0 · Accepted Answer · 2022-05-18 20:31:06Z

2

use:

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

answered May 18, 2022 at 20:31

player0

131k14 gold badges91 silver badges149 bronze badges

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

1 Answer 1