ADDRESS Function Explained
The ADDRESS function in Microsoft Excel returns a cell address as text, based on a given row and column number. It takes up to five arguments: row number, column number, [abs_num], [a1], and [sheet_text]. The abs_num argument is a logical value that specifies the type of reference to return. The a1 argument is a logical value that specifies the type of reference style to use. The sheet_text argument is an optional text string that specifies the name of the worksheet.
ADDRESS Function Syntax
ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])
- row_num: The row number in the cell reference.
- column_num: The column number in the cell reference.
- abs_num: (Optional) A logical value that specifies the type of reference. If omitted, the default is 1 (absolute).
- a1: (Optional) A logical value that specifies the type of reference style. If omitted, the default is 1 (A1 style).
- sheet_text: (Optional) The name of the worksheet to be used in the reference.