deepcalc
DocsADDRESS

ADDRESS

View as markdown/docs/functions/address.md Ask Claude about this pageOpens Claude with this page's address

Returns a cell address as text from row and column numbers.

  • Excel: Verified match
  • Google Sheets: Verified match
  • Returns: Text

Examples

=ADDRESS(2, 3)
Result $C$2
=ADDRESS(2, 3, 4, TRUE, "Sheet2")
Result Sheet2!C2

Syntax

ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])
row_num
number required
column_num
number required
abs_num
number optional defaults to 1
a1
boolean optional defaults to 1
sheet_text
text optional
AREASReturns the number of areas in a reference. HLOOKUPSearches first row and returns matching value. HYPERLINKThe text a link displays: clickability is the renderer's. INDEXReturns value at row and column in range. INDIRECTReturns reference specified by text string. LOOKUPLooks up value in one-row or one-column range.