Returns a cell reference specified by a string. Learn more
The INDIRECT function in Google Sheets is a formula that allows you to use a cell reference as a string in a formula. It takes a cell reference as a string and returns the value of the cell, allowing you to create dynamic references within your formulas.
The first argument, cellreferenceas_string, is a string that contains the cell reference you want to use. This can be either in A1 or R1C1 notation, depending on the value of the optional second argument.
The second argument, [isA1notation], is an optional Boolean value that specifies the notation of the cell reference in the first argument. If this argument is set to TRUE or is omitted, the cell reference is interpreted as A1 notation. If set to FALSE, the cell reference is interpreted as R1C1 notation.
Using the INDIRECT function can be helpful when you need to create a reference to a cell that changes dynamically, based on the value of another cell or some other condition.