How to Use ADDRESS Function

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.

Download: ADDRESS Function

Leave a Reply