ADDRESS function - Zoho Sheet - Help Guide

ADDRESS

Returns a cell reference as a string, given the row and column numbers.

 

Syntax


ADDRESS(row; column; [mode]; [ref_type]; [sheet])

row: A number specifying the row. E.g. 1

column: A number (not a letter) specifying the column. E.g. 2
mode: A number that determines whether the cell row/column is absolute or relative. Defaults to 1 if omitted.

1- Row and column absolute ($A$1)

2- Row absolute and column relative (A$1)

3- Row relative and column absolute ($A1)

4- Row and column relative (A1)
ref_type: A logical value that determines whether the reference style is A1 (TRUE) or R1C1 (FALSE). The value is set as TRUE by default.
sheet: A text string specifying the sheet. E.g. "Sheet 1" 

 

Remarks

  • When omitting an optional parameter in the syntax, use a ; or , to separate it from the next argument. For example, in =ADDRESS(1;2;;TRUE;"ADDRESS") the parameter mode has been omitted.


Examples 

  

Formula

Result

=ADDRESS(1;2;1;TRUE;"ADDRESS")

ADDRESS.$B$1

=ADDRESS(1;2;1;TRUE)

$B$1

=ADDRESS(1;2;2)

B$1

=ADDRESS(1;2;1;FALSE;"ADDRESS")

ADDRESS.R1C2


Get a hands-on experience of the function in the embedded range below.  



Possible Errors

 

Errors

Meaning

#N/A!

  • The function could not find the value it was asked to look for. Commonly occurs in VLOOKUP and similar functions.

#NAME!

  • The function name is incorrect or invalid.

  • The given defined name (if any) is invalid.

  • There is a typo in the defined name used in the function.

  • Double quotes are missing for text values in the function.

  • Colon missing in a cell range reference.

#VALUE!

  • The given argument's data type is incorrect or invalid.
    For example, the function =DATE(A1:A3) will return a #VALUE error when a text value is present in the range.

#REF!

  • The given cell reference is incorrect or invalid. This error may occur when a cell/range has been deleted, moved or pasted over.

 

Similar Functions