Builds a cell address as text from a row and column number, with options for absolute or relative style and a sheet name. Usually feeds INDIRECT.

Syntax

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

• Absolute address

  =ADDRESS(3,2) → $B$3

  Absolute by default.

• Relative address

  =ADDRESS(3,2,4) → B3

  abs_num 4 is fully relative.

• With a sheet

  =ADDRESS(3,2,1,TRUE,"Sheet2") → Sheet2!$B$3

  With a sheet name.

• Column letter from a number: =SUBSTITUTE(ADDRESS(1,n,4),"1","").
• Combine with MATCH to report where a value was found.
• abs_num: 1 $A$1, 2 A$1, 3 $A1, 4 A1.

• Returns text, not a reference; wrap in INDIRECT to use it.
• #VALUE! for row or column below 1.