How to Reference Another Sheet in Google Sheets
In this article, you will learn how to reference another worksheet in functions in Google Sheets. Learning this tip will help you to build up your Google Sheets effectively and efficiently for your purpose.
How to refer to another sheet in the functions
To refer to another worksheet in a formula, you can use the following format: 'Sheet Name'!Cell Reference. For example, if you wanted to reference cell A1 on a sheet called "Data" in a formula, you would use the following:
This tells the formula to look for the value in cell A1 on the sheet called "Data". Remember that sheet names containing spaces or special characters must be surrounded by single quotes (') in the formula.
If you want to refer to a range of cells on another sheet, you can use the same format, but include the range of cells you want to reference. For example, if you want to reference cells A1:B10 on the "Data" sheet, you would use the following:
You can also use cell references in the formula to create a dynamic range that will automatically adjust if you add or remove data from the worksheet. For example, if you want to reference all of the cells in column A on the "Data" sheet, starting from cell A1, you could use the following formula:
This will include all the cells in column A, from A1 down to the last cell containing data.