ADDRESS AREAS

ADDRESS

ADDRESS —

Synopsis

ADDRESS(row_num,col_num[,abs_num,a1,text])

Description

ADDRESS returns a cell address as text for specified row and column numbers.

a1 is a logical value that specifies the reference style. If a1 is TRUE or omitted, ADDRESS returns an A1-style reference, i.e. $D$4. Otherwise ADDRESS returns an R1C1-style reference, i.e. R4C4.

text specifies the name of the worksheet to be used as the external reference.

  • If abs_num is 1 or omitted, ADDRESS returns absolute reference.
  • If abs_num is 2 ADDRESS returns absolute row and relative column.
  • If abs_num is 3 ADDRESS returns relative row and absolute column.
  • If abs_num is 4 ADDRESS returns relative reference.
  • If abs_num is greater than 4 ADDRESS returns #VALUE! error.
  • If row_num or col_num is less than one, ADDRESS returns #VALUE! error.

Examples

ADDRESS(5,4) equals "$D$5".

ADDRESS(5,4,4) equals "D5".

ADDRESS(5,4,3,FALSE) equals "R[5]C4".

See also

COLUMNNUMBER.

ADDRESS AREAS