How to use ADDRESS Function in Excel

Posted on: April 24, 2021 in 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 XLOOKUP with Multiple Criteria in Excel
While Excel’s XLOOKUP function does not natively support multiple criteria…

How to Use XLOOKUP in Excel
XLOOKUP is a versatile function in Excel used for performing…

How to use LOWER Function in Excel
Excel Lower Function Converts all uppercase letters in a text…

How to use AVERAGE Function in Excel.
This function calculates the average from a list of numbers.…

How to use ACOSH function in excel
The ACOSH function returns the inverse hyperbolic cosine of a…