Friday, December 02, 2011

Google Docs : How to reference cell value in another sheet

Formula : '='+ '[SheetName]' + '!' + '[Cell]'
eg:
=Sheet1!E1

Update:  Article '10 Useful Google Spreadsheet Formulas You Must Know' contains few more useful tricks.

0 comments: