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