Using the Excel ADDRESS Function
SummaryThe Excel ADDRESS function is used to obtain the address of a cell given column and row numbers. For example, =ADDRESS(5,10) would return $J$5. The cell address can be in the current sheet or another sheet.
Syntax=ADDRESS (row_num, column_num, [abs_num], [a1], [sheet_text])
Syntax BreakdownRow Num
Required. A number specifying the row number to use in the cell reference.
Required. A number specifying the column number to use in the cell reference.
Optional. Used to specify the type of reference to return. The options are as follows:
Optional. Specifies the A1 or R1C1 reference style.
The A1 style has the columns labeled alphabetically and rows labeled numerically. The ADDRESS function will return the A1 style if the A1 argument is omitted or TRUE.
The R1C1 has both columns and rows labeled numerically. The function returns the R1C1 style if the A1 argument is FALSE.
Optional. Allows the user to find the address of a cell on another sheet. For example, =ADDRESS(2,2,,,"Sheet3) would return Sheet3!$B$2.
If the sheet_text argument is blank or no sheet name is used, the function will find the address of the cell on the current worksheet.