ADDRESS
Description
Returns a cell reference (address) as text.
Syntax
ADDRESS(
row_num
,
column_num
, [
abs_num
], [
a1_ref_style_flag
], [
sheet_text
])
- row_num: The row number for the cell.
- column_num: The column number for the cell.
- abs_num: Specifies whether to use absolute or relative referencing. 1 = absolute; 2 = absolute row and relative column; 3 = absolute column and relative row; 4 = relative. The default is 1.
- a1_ref_style_flag: The cell reference style. TRUE or Empty = A1 style; this is the only style that Worksheets supports.
- sheet_text: The sheet name. If not specified, the reference is for the current sheet.
Example
Formula | Result |
|---|---|
=ADDRESS(1,1) | $A$1 |
=ADDRESS(2,4,4,,"MySheet") | MySheet!D2 |