ADDRESS

When to use it

When should I use ADDRESS?

Use ADDRESS to build a cell-address string from row and column numbers — typically to construct a reference that is then passed to INDIRECT for a fully dynamic lookup.

Used in

operations

Syntax

ADDRESS(row, col, [abs_mode], [a1], [sheet_text])