Creates a cell reference as text, given specified row and column numbers.
Синтаксис
ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])Аргументы
row_numобязательно
The row number to use in the cell reference.
column_numобязательно
The column number to use in the cell reference.
abs_numнеобязательно
Specifies the type of reference (1=absolute, 2=abs row/rel col, 3=rel row/abs col, 4=relative).
The ADDRESS function is used to construct a cell reference string based on numeric row and column coordinates. It allows you to specify the reference type (absolute or relative) and the reference style (A1 or R1C1).
=ADDRESS(1, 1)→$A$1Returns the absolute reference for the cell at row 1, column 1.
=ADDRESS(2, 3, 4)→C2Returns the relative reference for the cell at row 2, column 3.
Enter row and column numbers
Provide the numeric row and column indices you wish to convert into a reference.
Define reference type
Optionally specify the abs_num argument to control whether the result is absolute or relative.
Yes, by providing the sheet_text argument, you can include the sheet name in the resulting reference string.