Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Lookup Reference Functions

 

=ADDRESS(2,3,1,FALSE,[Book1]Sheet1) return absolute reference to another workbook and worksheet

Input the formula: =ADDRESS(2,3,1,FALSE,"[Book1]Sheet1"). Press Enter to get the result.