=ADDRESS(2,3,2,FALSE) return absolute row; relative column in R1C1 reference style : ADDRESS « Lookup Reference functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Lookup Reference functions
  3. ADDRESS
Input the formula: =ADDRESS(2,3,2,FALSE). Press Enter to get the result.
Input the formula: =ADDRESS(2,3,2,FALSE)








19.1.ADDRESS
19.1.1.ADDRESS(row_num,column_num,abs_num,a1,sheet_text) returns a reference as text to a single cell in a worksheet
19.1.2.=ADDRESS(2,3) returns Absolute reference=ADDRESS(2,3) returns Absolute reference
19.1.3.=ADDRESS(2,3,2) return absolute row; relative column=ADDRESS(2,3,2) return absolute row; relative column
19.1.4.=ADDRESS(2,3,2,FALSE) return absolute row; relative column in R1C1 reference style=ADDRESS(2,3,2,FALSE) return absolute row; relative column in R1C1 reference style
19.1.5.=ADDRESS(2,3,1,FALSE,"[Book1]Sheet1") return absolute reference to another workbook and worksheet=ADDRESS(2,3,1,FALSE,
19.1.6.=ADDRESS(2,3,1,FALSE,"EXCEL SHEET") return absolute reference to another worksheet=ADDRESS(2,3,1,FALSE,
19.1.7.Return a worksheet column letter (ranging from A to XFD) for the value contained in cell A1.Return a worksheet column letter (ranging from A to XFD) for the value contained in cell A1.