Return address of a cell in Excel
Returns a reference as text to a single cell in a worksheet


Return address of a cell.


The Excel ADDRESS function returns the address of a cell (position) based on the given specified row and column numbers of a worksheet. For example, if you pass ADDRESS(5,6) the function returns $F$5.


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


row_num -The row number to find the address
column_num – The column number to find the address
abs_num [Optional] – Cell address type (absolute and relative)

Return Value

Cell address of a reference cell

Key Notes

  • The ADDRESS function accepts a row and column reference and returns a cell address.
  • Return an absolute or relative format of a reference cell.

Following are abs_num argument types:

abs_num Returns this type of reference
1 or omitted Absolute row and column
2 Absolute row and relative column
3 Relative row and absolute column
4 Relative row and column


Keep Reading Similar Functions:

Returns value from a data as per given offset range in Excel


The OFFSET function returns one or multiple data points of a data set by giving a reference point with a specified number of rows and columns to offset.

Read More »
Return a cell value as per row‐and‐column intersection in Excel


The INDEX function returns a cell value from one or multiple data range at a given row‐and‐column intersection and gets a specific value from a data set.

Read More »
Returns a reference indicated by a text value


The INDIRECT function creates a cell reference from a given text string same as the name of a worksheet and extracts value from a specific cell.

Read More »