How to Use IMPORTRANGE with Conditions using Query function

To use IMPORTRANGE with conditions using the Query function in Google Sheets, follow these steps:

1. First, make sure you have access to both the source sheet and the destination sheet.
2. In the destination sheet, click on the cell where you want the imported data to appear.
3. Use the IMPORTRANGE function to import data from the source sheet. The syntax for this function is: IMPORTRANGE("spreadsheet_url", "range_string"). Replace "spreadsheet_url" with the URL of the source sheet, and "range_string" with the range of data you want to import.
4. Next, use the QUERY function to apply conditions to the imported data. The syntax for this function is: QUERY(data, query, [headers]). Replace "data" with the IMPORTRANGE function from step 3, "query" with the SQL-like query to filter the data, and "[headers]" with the number of header rows in the data (optional).

Here's an example to illustrate the process:

Example

Let's say you want to import data from a source sheet and only display rows where the age is greater than 30. The source sheet URL is "https://docs.google.com/spreadsheets/d/1aBcDeFgHiJkLmNoPqRsT-uvwxyz/edit" and the data range is "Sheet1!A1:C100".

In the destination sheet, click on the cell where you want the imported data to appear, and enter the following formula:

=QUERY(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1aBcDeFgHiJkLmNoPqRsT-uvwxyz/edit", "Sheet1!A1:C100"), "SELECT * WHERE Col2 > 30", 1)

This formula imports data from the source sheet using IMPORTRANGE and then applies the QUERY function to filter the data. The query "SELECT * WHERE Col2 > 30" selects all rows where the value in column B (Col2) is greater than 30. The number "1" at the end of the formula indicates that there is one header row in the data.

After entering the formula, press Enter, and the filtered data will be displayed in the destination sheet.