How to use ADDRESS Function in Excel

Posted on: April 24, 2021 in Excel , Excel Functions ,

Description

The ADDRESS function to obtain the address of a cell in a worksheet, returns the address for a cell based on a given row and column number.

For example, ADDRESS(4,2) returns $B$4.

4 – indicates row 4 , 2 indicates Column B ( First column A second Column B )

Syntax


=ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])

Arguments

row_num Required.

row_num must be specified. That must be a numeric value.

A numeric value that specifies the row number to use in the cell reference.

column_num Required. A numeric value that specifies the column number to use in the cell reference.

[abs_num] Optional. A numeric value that specifies the type of reference to return.

[a1] [optional] The reference style, A logical value that specifies the A1 or R1C1 reference style. Defaults to A1 style.

[Sheet-text] – [optional] The name of the worksheet to use. Defaults to current sheet.

[abs_num] key

1 – Absolute [Default]

2 – Absolute row / Relative Column

3 – Relative Row / Absolute Column

4 – Relative

Return Value

A cell address in the current or given worksheet.

Examples


=ADDRESS(1,2) returns $B$1 [abs_num] 1 is default

=ADDRESS(1,2,2) returns B$1 [abs_num] 2

=ADDRESS(1,2,3) returns $B1 [abs_num] 3    

=ADDRESS(1,2,4) returns B1 [abs_num] 4

Share your thoughts Cancel reply

How to use LOWER Function in Excel
Excel Lower Function…

How to use AVERAGE Function in Excel.
This function calculates…

How to use ACOSH function in excel
The ACOSH function…

How to use ACOT function in excel
The Excel ACOT…

How to use ACOS function in excel
This function is…