Reference
No results for 'undefined'
    Powered by Algolia

    ADDRESS

    Returns a cell reference

    Syntax

    =ADDRESS(row, column, [sheet])

    Parameters

    1. row
      • Type: Integer
      • Description: Row number
    2. column
      • Type: Integer
      • Description: Column number
    3. sheet [optional]
      • Type: String
      • Description: A string indicating the name of the sheet into which the address points. Current sheet name by default.

    Features

    • Modifies spreadsheet.

    Returns

    • Type: Frame
    • Description: Returns a cell reference
    =ADDRESS(1, 1, "Sheet1")

    See Also

    Contents