Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

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 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 »
Create a cell reference using a text string in Excel

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 »
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 »