How to use ADDRESS Function in Excel

How to use ADDRESS Function in Excel2018-11-19T12:30:17+00:00
Insert Image

You can use ADDRESS function in Excel to create a cell address by specifying a row and a column number.

In simple words, you need to specify a reference by providing row and column number as an argument, it returns a cell range as a text.

For example, if you give row number 2 and column number 1 it will return A2 in the result.

Syntax

ADDRESS(row_num,column_num,abs_num,A1,sheet_text)

Argument which are in square brackets are optional.

Examples: ADDRESS Function

In the below example, we have used different arguments to get all types of result.

how to use address function in excel examples
  1. With R1C1 reference style
    1. Relative reference.
    2. Relative row and absolute column reference.
    3. Absolute row and relative column reference.
    4. Absolute reference.
  2. With A1 reference style
    1. Relative reference.
    2. Relative row and absolute column reference.
    3. Absolute row and relative column reference.
    4. Absolute reference.