SheetFX
≡
<< Go back to all functions

INDIRECT

The INDIRECT function in Google Sheets returns a cell reference specified by a string.

Function Syntax and Parameters

Syntax: INDIRECT(cell_reference_as_string, [is_A1_notation])

Parameters:

  • cell_reference_as_string: The cell reference as a string.
  • is_A1_notation: [Optional] A boolean value that specifies whether the cell reference is in A1 notation (TRUE) or R1C1 notation (FALSE). The default value is FALSE.

Step-by-Step Tutorial

  1. Using INDIRECT with A1 notation:

    • Example: =INDIRECT("A1")
    • Result: The value in cell A1.

  2. Using INDIRECT with R1C1 notation:

    • Example: =INDIRECT("R1C1", TRUE)
    • Result: The value in the first row and first column.

Use Cases and Scenarios

  1. Dynamic Cell References: Access a cell that is determined by the value of another cell.
  2. Conditional Formulas: Reference cells based on certain conditions.
  3. Automation: Simplify complex formulas by dynamically changing cell references.

Related Functions

  • ADDRESS: Returns a cell reference as a string.
  • ROW: Returns the row number of a specified cell.
  • COLUMN: Returns the column number of a specified cell.

Related Articles