ADDRESS
Returns a reference as text to a single cell in a worksheet
Syntax
ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])
Parameters
- row_num: Required. The row number to use in the cell reference
- column_num: Required. The column number to use in the cell reference
- abs_num: Optional. The type of reference to return (1=absolute, 2=abs row/rel col, 3=rel row/abs col, 4=relative)
- a1: Optional. A logical value: TRUE for A1-style, FALSE for R1C1-style
- sheet_text: Optional. The name of the worksheet to use as the external reference
Example
=ADDRESS(2, 3, 1, TRUE)