ADDRESS(row_num,column_num,abs_num,a1,sheet_text) returns a reference as text to a single cell in a worksheet : ADDRESS « Lookup Reference functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Lookup Reference functions
  3. ADDRESS
abs_num specifies the type of reference to return.

1 or omitted, returns Absolute

2, returns Absolute row; relative column

3, returns Relative row; absolute column

4, returns Relative

If a1 is TRUE or omitted, ADDRESS returns an A1-style reference.

If a1 is FALSE, ADDRESS returns an R1C1-style reference.

sheet_text is the name of the worksheet.

Referenced from Excel Help









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.