Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this community
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?
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'")
