Google Sheets Function

ADDRESS

Creates a cell reference as text, given specified row and column numbers.

Generate a formula with AI Same function in Excel

This function works the same in Google Sheets as it does in Excel — same syntax and arguments.

Syntax

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

The ADDRESS function is used to construct a cell reference string based on numeric row and column coordinates. It allows you to specify the reference type (absolute or relative) and the reference style (A1 or R1C1).

Arguments

row_numrequiredThe row number to use in the cell reference.
column_numrequiredThe column number to use in the cell reference.
abs_numoptionalSpecifies the type of reference (1=absolute, 2=abs row/rel col, 3=rel row/abs col, 4=relative).

Examples

=ADDRESS(1, 1)

Result: $A$1

Returns the absolute reference for the cell at row 1, column 1.

=ADDRESS(2, 3, 4)

Result: C2

Returns the relative reference for the cell at row 2, column 3.

FAQ

Can ADDRESS return a reference to another sheet?

Yes, by providing the sheet_text argument, you can include the sheet name in the resulting reference string.

Related functions

INDIRECT INDEX OFFSET