Updated: November 21, 2026

If you need to reference another sheet in Google Sheets, the key is simple, use the sheet name plus the cell address, and your formula can pull data from a different tab instantly. That lets you build summaries, dashboards, and linked calculations without copying values by hand. Once you know the syntax, you can also reference another workbook, use absolute references, and make formulas that stay stable when you fill them down.

Reference Another Sheet with a Basic Cell Formula

To reference another sheet, start a formula with an equals sign, then type the sheet name, an exclamation point, and the cell address. This is the standard Google Sheets formula reference another sheet pattern and it works for direct cell pulls.

Basic syntax

If the sheet is named Sales and you want cell A1, use:

=Sales!A1

If the sheet name has spaces, wrap it in single quotes:

=’Monthly Sales’!A1

This is the clearest answer to how to link to another sheet and how to reference another sheet cell. It also works for google sheets cell reference another sheet searches and google sheets cell reference queries.

Reference a range

You can pull more than one cell at once. A range reference looks like this:

=Sales!A1:D10

This returns the values from the selected block. Use it when you want to copy a table, feed another formula, or build a chart from another tab.

Link Data Across Sheets and Other Tabs

To link one sheet to another, place the reference directly inside the cell where you want the result. The destination cell becomes dependent on the source cell, so if the original value changes, the linked value updates automatically. That answers google sheets formula link to another sheet and google sheets refer to another sheet.

Pull a value into a summary sheet

  1. Click the cell where you want the linked value.
  2. Type =.
  3. Switch to the source tab.
  4. Click the source cell.
  5. Press Enter.

Google Sheets writes the reference for you, which is the fastest way to handle google sheets how to reference another cell and google sheets how to reference another sheet without typing the address manually.

Reference another sheet in a formula

You can combine sheet references with functions. For example:

=SUM(Sales!B2:B20)

=AVERAGE(‘Q1 Data’!C2:C12)

This is the right pattern when you need a formula reference another sheet, not just a raw cell link. It also supports google sheets reference another sheet dynamic setups when paired with functions like INDIRECT.

Use Absolute References When You Copy Formulas

Absolute references lock a row, a column, or both. In Google Sheets, the dollar sign does the locking, which is what people mean by google sheets absolute reference formula or google sheets $ in formula absolute reference.

Absolute row, absolute column, and fully locked references

Use these forms:

  • $A$1 locks both column A and row 1.
  • A$1 locks row 1 only.
  • $A1 locks column A only.

If you use a reference in a formula and drag it down, the dollar signs keep the target fixed. That is the core of google sheets absolute reference and google sheets absolute row reference.

Why it matters with another sheet

Suppose column B on a summary sheet should always divide by a tax rate in Settings!B2. Use:

=A2/Settings!$B$2

Now the source value changes by row, but the tax rate stays fixed. This is the cleanest way to handle google sheets absolute reference function use cases in real spreadsheets.

Reference Another Spreadsheet or Workbook

When you need data from a different file, Google Sheets can reference another document through IMPORTRANGE. This covers google sheets reference another spreadsheet, google sheets reference another workbook, and google sheets reference another file.

Use IMPORTRANGE

The syntax is:

=IMPORTRANGE(“spreadsheet_url”,”Sheet1!A1:D10″)

Replace the URL with the source file and the second argument with the sheet name and range you want. The first time you use it, Sheets asks you to allow access between the files.

When to use it

Use a direct sheet reference for tabs inside the same file. Use IMPORTRANGE when the data lives in a separate spreadsheet file. That is the direct answer to google sheets can you reference another sheet, if the “other sheet” sits in another document, the answer is yes, through IMPORTRANGE.

Make a Dynamic Reference to Another Sheet

Dynamic references change based on a cell value, which is useful when you want one formula to pull from different tabs. This is the main approach for google sheets reference another sheet dynamic requests.

Use INDIRECT for a dynamic sheet name

If cell A1 contains the sheet name, use:

=INDIRECT(“‘”&A1&”‘!B2”)

If A1 says Q1 Data, the formula reads Q1 Data!B2. The single quotes around the sheet name protect names that contain spaces.

Common use cases

Dynamic references are useful when you build monthly tabs, region tabs, or department tabs. One formula can point to different sheets without rewriting the reference each time. If the sheet name changes, update the control cell and the result follows.

Reference Another Cell in a Formula or QUERY Setup

Google Sheets cell reference formula questions usually fall into two groups, simple references and references inside functions. In both cases, the cell address is the same, but the formula context changes.

Inside QUERY

The QUERY function can use a range from another sheet, like this:

=QUERY(Sales!A1:F100,”select A, sum(F) where A is not null group by A”,1)

Here, Sales!A1:F100 is the cell reference source, and QUERY reads the header row because the last argument is 1. This is the practical answer to google sheets query function cell reference.

Inside other formulas

You can mix cross-sheet references with IF, SUMIF, FILTER, and VLOOKUP. For example:

=IF(Inventory!C2>0,”In stock”,”Out of stock”)

This keeps logic on one sheet while pulling values from another. It is a clean way to reference other sheet data without duplicating it.

Frequently Asked Questions

Can you reference another sheet in Google Sheets?

Yes. Use =SheetName!A1 for a cell in the same file, or =IMPORTRANGE() for a cell in another spreadsheet file.

How do I reference another sheet with spaces in the name?

Put the sheet name in single quotes, then add the cell address. For example, =’Project Budget’!C5.

How do I keep a sheet reference fixed when copying a formula?

Use dollar signs, such as Sheet1!$B$2. That locks the row and column so the reference does not shift.

How do I reference another workbook or file?

Use IMPORTRANGE with the source file URL and the range you want, such as =IMPORTRANGE(“url”,”Sheet1!A1:B20″).

How do I build a dynamic reference to another sheet?

Use INDIRECT and build the sheet name from a cell value, such as =INDIRECT(“‘”&A1&”‘!B2”).