Referencing Sheets

Eventually, everyone will need to know how to reference data from more than one Sheet at the same time. I will show you the basics here for how google sheets makes you refer to another sheet. I will show you how to do so in just a few easy steps. Using google sheet, reference another sheet with ease this and every time in the future.

Step #1: Know Your Coordinates

Referencing Sheets Step 1A
Referencing Sheets Step 1B

At the bottom of the page (sometimes called the google sheets workbook), you will see a list of your sheets. In Sheet 1, I have one column of numbers, in Sheet 2, I have a second column of numbers.

Side Note: is that you can rename your sheets to help organize your sheets. simply right click the sheet tab and select "Rename

In sheet 2, the column starts at Cell B2, which is important to remember for the next step.

Step #2: "=Sheet2!(Cell)"

Referencing Sheets Step 2

In this case, I will be multiplying between the two sheets on sheet 1. The Function that you want to use for referencing the cell is gonna be "Sheet2!B2"

here, you have the function structured as

"Sheet Name+!+Cell Coordinate" 

From here, the cell will be properly referenced and behave as if it existed in that sheet. With this function, we can use google sheets' reference function to pull data from multiple sheets with ease.

Step #3: Verify Results

Referencing Sheets Step 3

If you click and drag down the column, the reference command will apply the same way so long as there are cells to reference in the new sheet. Always feel free to check the math and make sure everything was referenced properly.

And there you have it; that is how you reference sheets in Google Sheets. You can use Sheet referencing for really cool collaborative functions like Import-Range, that let you relocate entire spreadsheets within Google Sheets.

Leave a Reply

Your email address will not be published. Required fields are marked

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Google Sheets Magic Tricks!

Interactive, Easy and Free Way to Learn 5 Awesomely Cool Google Sheets Tricks!