In Google Sheets I'm using IMPORTRANGE to pull in a large list of data (about 400 rows, 6 columns) and I want to only display rows where column D matches EXAMPLE TEXT.

For example: if column D of the IMPORTRANGE source says "Value A" then that row is successfully displayed on the destination sheet.

Is this a possible?

1 Answer 1


The QUERY function will do what I want. I had no idea that I could use database like functions in Sheets.

=QUERY(IMPORTRANGE("insert_url","Range"),"Select Col1, Col2 Where Col4='Value'")


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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