I would like to use the importrange formula to import data from "spreadsheetA" that contains "keyword" in columnD.

I can get importrange to work but I cannot figure out how to filter it so it will only import if a keyword is found in column d.


You nest an import range to a query to meet your desired result:

=query(IMPORTRANGE("key","Sheet1!A:C"),"Select * Where Col2 contains 'Keyword'") 

Demo sheet for you:


If you get a REF error you need to give yourself or get permission from the owner to read data from that sheet.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.