Mega Code Archive
Categories
/
MSOfficeExcel 2007 Tutorial
/
Lookup Reference Functions
=ADDRESS(2,3,1,FALSE,EXCEL SHEET) return absolute reference to another worksheet
Input the formula: =ADDRESS(2,3,1,FALSE,"EXCEL SHEET"). Press Enter to get the result.