Excel Function : ADDRESS
Category
Lookup and reference
Description
Returns a reference as text to a single cell in a worksheet
Microsoft Excel Reference Page
https://support.office.com/en-us/article/ADDRESS-function-d0c26c0d-3991-446b-8de4-ab46431d4f89
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
