Excel ADDRESS Function

Excel ADDRESS Function

Sponsored Link

Purpose 

Create a cell address from a given row and column

Return value 

A cell address in the current or given worksheet.

Syntax 

=ADDRESS (row_num, col_num, [abs_num], [a1], [sheet])

Arguments 

  • row_num – The row number to use in the cell address.
  • col_num – The column number to use in the cell address.
  • abs_num – [optional] The address type (i.e. absolute, relative). Defaults to absolute.
  • a1 – [optional] The reference style, A1 vs R1C1. Defaults to A1 style.
  • sheet – [optional] The name of the worksheet to use. Defaults to current sheet.

Usage notes 

Use ADDRESS to create an address from a given row and column number. For example, ADDRESS(1,1,) will return $A$1.

Abs_num key:
1 or omitted  Absolute
2  Absolute row; relative column
3  Relative row; absolute column
4  Relative

Sponsored Link

0 votes. 0 / 5

Excel - Excel Functions - Excel Formulas
Logo