ADDRESS(row_num, column_num [,abs_num] [,a1] [,sheet_name])

Returns the cell reference given a row and column number.

row_numThe row number to use in the cell reference between 1 and 65,536.
column_numThe column number to use in the cell reference between 1 and 256.
abs_num(Optional) The number indicating the type of reference to return:
1 = absolute ($A$1) (default)
2 = absolute row/relative column (A$1)
3 = relative row/absolute column ($A1)
4 = relative (A1)
a1(Optional) Whether to return A1 or R1C1 reference notation:
True = A1 notation is returned (default)
False = R1C1 notation is returned
sheet_name(Optional) The name of the worksheet to be used as the external reference.

* If "row_num" < 1, then #VALUE! is returned.
* If "col_num" < 1, then #VALUE! is returned.
* If "abs_num" is left blank, then 1 is used.
* If "a1" = True then the A1 style reference is returned.
* If "a1" = False then the R1C1 style reference is returned.
* If "a1" is left blank, then True is used.
* If "sheet_name" is left blank, then the cell reference will refer to the active sheet.
* The "sheet_name" does not have to be the name of a worksheet that actually exists.
* The "row_num" can be a cell reference that evaluates to a number.
* The "col_num" can be a cell reference that evaluates to a number.
* For the Microsoft documentation refer to support.office.com.

 AB
1=ADDRESS(2,3) = $C$26
2=ADDRESS(2,3,1) = $C$213
3=ADDRESS(2,3,2) = C$2 
4=ADDRESS(2,3,3) = $C2 
5=ADDRESS(2,3,4) = C2 
6=ADDRESS(B1,3,4) = C6 
7=ADDRESS(2,B2,4) = M2 
8=ADDRESS(2,3,2,FALSE) = R2C[3] 
9=ADDRESS(2,3,1,FALSE,"[Book1]Sheet1") = [Book1]Sheet1!R2C3 
10=ADDRESS(2,3,1,FALSE,"Excel Sheet") = 'Excel Sheet'!R2C3 
11=ADDRESS(2,2,2,1,"worksheet_name") = worksheet_name!B$2 
12=ADDRESS(-1,2) = #VALUE! 
13=ADDRESS(2,-1) = #VALUE! 
14=ADDRESS(-1,-1) = #VALUE! 


© 2017 Better Solutions Limited. All Rights Reserved. © 2017 Better Solutions Limited