How to reference a cell in another sheet in Google Spreadsheets
I've finally started using multiple sheets in Google spreadsheets. I found I was creating multiple spreadsheets, for tracking different items, but all containing the same tracking columns. So, I put them into one spreadsheet, and created one master sheet to track running totals compiled from each sheet.
So, if you need to do this, and want to reference a value in another sheet, it's actually quite simple. You just need the name of the sheet, and the cell location. So, if the sheet was named "Sheet2" (creative, huh?!), and the cell was C3, you could reference the value from any sheet with this formula:
=Sheet2!C3
However, I ran into one error, when I had an ampersand ("&") character in my sheet name. It gave a 'circular reference detected' error. I guess it thought the "&" was part of the equation. So just use alphanumeric characters when naming your sheets, and you should be fine.
on July 19th, 2009 at 6:24 am
If you use special chars, then use single quotes to wrap the names. For example, if your Sheet is called Alpha&Bravo, reference it as 'Alpha&Bravo'!C3
on September 6th, 2009 at 6:12 pm
It doesn't seem to work without single-quoting the sheet name:
='Sheet1'!A1
='Name of my sheet'!C99
on September 6th, 2009 at 11:11 pm
If I need to reference another spreadsheet? how that it would be?
on January 19th, 2010 at 11:05 pm
Can I refer to a value in another spreadsheet document?
on February 19th, 2010 at 6:40 pm
Thanks, this was a really helpful tip.
on June 29th, 2011 at 11:57 am
Here is a question, how to access a google spreadsheet cell value to determine which graphic to load into an html spreadsheet using javascript?
on October 23rd, 2011 at 3:31 pm
Perfection, google should give you a stock share, seriously…