Reference another sheet in Google Sheets: Step-by-step guide
Learn how to reference another sheet in Google Sheets, including same-workbook cross-sheet references, handling spaces in sheet names, and cross-workbook imports with IMPORTRANGE. This How To Sheets guide covers syntax, practical examples, common pitfalls, and best practices for reliable data consolidation across sheets.
Why reference another sheet in Google Sheets?
References across sheets are essential for building dashboards, consolidating data, and reusing calculations. When your data live in multiple tabs, cross-sheet references keep formulas dynamic as data changes, reducing duplication. According to How To Sheets, adopting consistent referencing practices improves maintainability and reduces errors in large spreadsheets. In practice, you reference a cell or range by prefixing it with the target sheet name, followed by an exclamation mark. This lets Google Sheets pull the latest value from the source sheet automatically.
=Sheet2!A1='Sheet 2'!A1Tip: Using INDIRECT can create dynamic references, but it can break if sheets are renamed or deleted. Example:
=INDIRECT("Sheet2!A1")Note: Indirect can be volatile in large workbooks and may slow performance.