Excel Function – ADDRESS()

Description

To calculate the address of a cell in an worksheet. You can use this function to refer cells in other worksheets as well.

Syntax

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

• row_num: specifies the row number
• col_num: specifies the column number
• [abs_num]: optional, which row or column to be fixed (absolute) with $ or relative
• [a1]: optional, it specifies A1 or R1C1 reference style if set to False or left blank.
• [sheet_text]: optional, specifies which worksheet to reference to.

abs_num table below:

Examples

Below are the examples of using ADDRESS() function. Note for the last 2 examples, I used another small table with refrence values in column E.

ADDRESS is a very flexible function and can be used with INDIRECT to enable the extraction of a value of the addressed cell. This value can then be use for SUM or any other calculation.

References

Check out how to use INDIRECT() function.