ADDRESS

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

Rational

Return address of a cell.

Description

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.

Syntax

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

Parameters

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_numReturns this type of reference
1 or omittedAbsolute row and column
2Absolute row and relative column
3Relative row and absolute column
4Relative row and column

 

Keep Reading Similar Functions:

Returns a reference indicated by a text value

INDIRECT

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 »
Returns value from a data as per given offset range in Excel

OFFSET

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

INDEX

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 »