How to use ADDRESS Function in Excel

blog img


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 )


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


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.


=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

Your email address will not be published. All fields are required.

Related post

  1. How to use LOWER Function in Excel

    Excel Lower Function…

  1. How to use AVERAGE Function in Excel.

    This function calculates…

  1. How to use ACOSH function in excel

    The ACOSH function…

  1. How to use ACOT function in excel

    The Excel ACOT…

  1. How to use ACOS function in excel

    This function is…