ADDRESS
Syntax:
ADDRESS ( row-number , col-number [ , [ ref-type ] [ , [ A1-ref-style-flag ][ , sheet-name ] ] ] )
Description: Creates a cell address, given the specified row and column numbers.
Arguments:
Name |
Type |
Description |
||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
row-number |
number |
The number of the row. |
||||||||||
col-number |
number |
The number of the column. |
||||||||||
ref-type |
number |
The type of reference to return, as follows:
|
||||||||||
A1-ref-style-flag |
logical |
The style of the reference. If |
||||||||||
sheet-name |
text |
The name of the worksheet to be used. If omitted, no sheet name is used. |
Return Type and Value: text – A cell address, given the specified row and column numbers.
However, if
row-number or col-number < 1,
#NUM!
is returned.ref-type is outside the range 1–4,
#NUM!
is returned.
ADDRESS(5,7,2) results in G$5
ADDRESS(5,7,3) results in $G5
ADDRESS(5,7,4) results in G5
ADDRESS(5,7,,,"Sheet1") results in Sheet1!$G$5In R1C1-reference style mode:ADDRESS(5,7,1,FALSE) results in R5C7ADDRESS(5,7,2,FALSE) results in R5C[7]
ADDRESS(5,7,3,FALSE) results in R[5]C7
ADDRESS(5,7,4,FALSE) results in R[5]C[7]