Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Lookup Reference Functions

 

=ADDRESS(2,3,2,FALSE) return absolute row; relative column in R1C1 reference style

Input the formula: =ADDRESS(2,3,2,FALSE). Press Enter to get the result.