Excel Function : ADDRESS

Download now!

Excel Function : ADDRESS


Lookup and reference


Returns a reference as text to a single cell in a worksheet

Microsoft Excel Reference Page


Syntax and Description of the ADDRESS Excel Function

? The syntax for the ADDRESS function in Microsoft Excel is: =ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])

About ADDRESS Excel Function

The ADDRESS function returns a cell address as a text string. =ADDRESS(row, column, [abs_num], [a1], [sheet_text]) Row - The row number of the cell. Column - The column number of the cell. Abs_num - [optional] The absolute number. Can be one of the following values: 1 - [Default] The cell reference is relative to the upper-left corner of the worksheet. 2 - The cell reference is absolute. A1 - [optional] The A1 reference style. Can be one of the following values: 1 - [Default] Use the A1