The ADDRESS function is one of the 16 Excel Reference Functions. The function returns the address of a cell in a worksheet with the specified row and column numbers.
Formula:
= ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])
Explanation:
- Row_num is required, the specified row number.
- Column_num is required, the specified column number.
- Abs_num is optional, the numeric value to specify the type of reference to return.
- A1 is optional, the logical value for A1 or R1C1 reference style.
– When A1 argument is true or omitted, the function returns an A1 reference style, which columns are labeled alphabetically, and rows are labeled numerically.
– When A1 argument is false, the function returns R1C1 reference style, which both columns and rows are labeled numerically. - Sheet_text is optional, the worksheet name to be used in the external reference.
= ADDRESS(2,4) returns absolute reference $C$2.
= ADDRESS(2,4,4) returns relative reference C2.
= ADDRESS(2,4,4,false) returns R1C1 reference style, relative R[2]C[4].
= ADDRESS(2,4,3,false) returns R1C1 reference style, relative row and absolute column R[2]C4.
= ADDRESS(2,4,2,false, "sheet2") returns absolute reference style with absolute row and relative column in the wordsheet name of "sheet2": SHEET2!D$2.