SheetFX
≡
<< Go back to all functions

ADDRESS

The ADDRESS function in Google Sheets is a powerful tool that allows you to convert row and column numbers into a cell reference. It returns a cell reference as a string, which can be highly useful in various scenarios. Learn how to use the ADDRESS function effectively with our comprehensive guide.

Function Syntax and Parameters

Syntax: ADDRESS(row, column, [absolute_relative_mode], [use_a1_notation], [sheet])

Parameters:

  • row: The row number that you want to reference.
  • column: The column number that you want to reference.
  • absolute_relative_mode: [Optional] Determines whether the reference is absolute or relative. Defaults to 1 (absolute).
  • use_a1_notation: [Optional] Determines whether the reference uses A1 notation or R1C1 notation. Defaults to TRUE (A1 notation).
  • sheet: [Optional] The name or index of the sheet. Defaults to the current sheet.

Step-by-Step Tutorial

  1. Using ADDRESS with row and column numbers:

    • Example: =ADDRESS(3, 2)
    • Result: $B$3 (or Sheet1!B3 if the sheet name is provided)

  2. Using ADDRESS with absolute or relative references:

    • Example: =ADDRESS(3, 2, 2)
    • Result: B3 (without the dollar signs)

  3. Using ADDRESS with R1C1 notation:

    • Example: =ADDRESS(3, 2, , FALSE)
    • Result: R3C2 (instead of A1 notation)

Use Cases and Scenarios

  1. Data Manipulation: Use the ADDRESS function to dynamically reference cells based on certain conditions.

Related Functions

None

Related Articles

None