ADDRESS function

This function will return the address of a cell given a specified row and column index number.

Syntax

ADDRESS(Row, Column, Reference Type, Address Type, Sheet Name)

  • Row (required) – This is a number that specifies the row of the address.
  • Column (required) – This is a number that specifies the column of the address.
  • Reference Type (optional) – This is a number (1, 2, 3 or 4) that specifies if the address is a relative or absolute reference.
    • 1 – Absolute row and absolute column reference ($A$1 or R[1]C[1]).
    • 2 – Absolute row and relative column reference (A$1 or R[1]C1).
    • 3 – Relative row and absolute column reference ($A1 or R1C[1]).
    • 4 – Relative row and relative column reference (A1 or R1C1).
  • Address Type (optional) – This is a TRUE or FALSE value that specifies if the address is A1 or R1C1 reference type.
    • TRUE or 1 – Results in a A1 style reference.
    • FALSE or 0 – Results in a R1C1 style reference.
  • Sheet Name (optional) – This the sheet name to be used in the address.

Example

In this example we display different variations of the cell in address for row 5 and column 2. We also add a sheet name reference in front.

=ADDRESS(A2,B2,C2,D2)


ADDRESS

About the Author

John MacDougall

John MacDougall

John is a Microsoft MVP and qualified actuary with over 15 years of experience. He has worked in a variety of industries, including insurance, ad tech, and most recently Power Platform consulting. He is a keen problem solver and has a passion for using technology to make businesses more efficient.

Related Posts

ROW function

This function will return the row number of the cell referenced. Syntax...

read more

Comments

0 Comments

Get the Latest Microsoft Excel Tips

Follow Us

Follow us to stay up to date with the latest in Microsoft Excel!

Subscribe for awesome Microsoft Excel videos 😃