Formualizer Docs
ReferenceFunctionsLookup Functions

ADDRESS

ADDRESS: Returns a cell reference as text from row and column numbers.

Summary

ADDRESS can emit either A1 or R1C1 notation and optionally prefix the address with a sheet name.

Remarks

  • abs_num defaults to 1 ($A$1) and supports values 1..4.
  • a1 defaults to TRUE; FALSE returns R1C1-style text.
  • Valid row range is 1..1048576; valid column range is 1..16384.
  • Out-of-range row/column values or invalid abs_num return #VALUE!.
  • If sheet_text contains spaces or special characters, it is quoted.

Examples

Absolute A1 reference
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
$C$2
Relative R1C1 reference with sheet
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
'Data Sheet'!R[5]C[3]

FAQ

What happens when abs_num is outside 1..4?

ADDRESS returns #VALUE!; only 1 (absolute), 2 (absolute row), 3 (absolute column), and 4 (relative) are valid.

Why does sheet_text sometimes add single quotes?

Sheet names containing spaces or special characters are quoted and internal apostrophes are escaped to keep a valid reference string.

Runtime metadata

Category

Lookup

Signature

ADDRESS(arg1: Number, arg2: Number, arg3?: Number, arg4?: Logical, arg5?: Text)

Arity

min 2, max 5

Arguments

arg1

Number · Scalar · coercion NumberStrict

arg2

Number · Scalar · coercion NumberStrict

arg3optionaldefault

Number · Scalar · coercion NumberStrict

arg4optionaldefault

Logical · Scalar · coercion Logical

arg5optional

Text · Scalar

Caps

PURE

Source

crates/formualizer-eval/src/builtins/lookup/address.rs

Registration entry at crates/formualizer-eval/src/builtins/lookup/mod.rs.

Lookup Functions

Generated reference pages for Lookup functions.

CHOOSE

CHOOSE: Returns one value from a list using a 1-based index.

On this page

SummaryRemarksExamplesRelated functionsFAQWhat happens when abs_num is outside 1..4?Why does sheet_text sometimes add single quotes?Runtime metadata