Google Sheets pull data from another tab based on criteria

To make Google Sheets pull data from another tab based on criteria, you can use the QUERY function combined with the IMPORTRANGE function. Here’s the general process:

In your destination tab, enter the following formula in a cell where you want the filtered data to appear:

=QUERY(IMPORTRANGE("SPREADSHEET_URL", "SOURCE_TAB_NAME!A:Z"), "SELECT * WHERE CRITERIA")

Replace “SPREADSHEET_URL” with the URL of the source spreadsheet and “SOURCE_TAB_NAME” with the name of the tab that contains the data you want to pull. Adjust the range “A:Z” to match the range of your data, and replace “CRITERIA” with the filter condition that defines which rows to include.

1. When you enter the formula, you’ll see an error message and a prompt to grant access to the source spreadsheet. Follow the on-screen instructions to authorize the access.
2. After granting access, the filtered data should appear in the cell where you entered the formula.

Here’s an example to illustrate the process. Let’s say you have a spreadsheet with two tabs: “SourceData” and “FilteredData”. In the “SourceData” tab, you have columns A to C with data, and you want to pull only rows where the value in column C is greater than 10.

In the “FilteredData” tab, enter the following formula in cell A1:

=QUERY(IMPORTRANGE("SPREADSHEET_URL", "SourceData!A:C"), "SELECT * WHERE C > 10")

Replace “SPREADSHEET_URL” with the URL of your source spreadsheet. After granting access, the “FilteredData” tab will display the rows from “SourceData” where the value in column C is greater than 10.

Remember to adjust the range and criteria according to your specific needs.

More Articles: