INDIRECT

Returns a cell reference specified by a string.

Parameter List

Syntax
INDIRECT(cell_reference_as_string
[is_A1_notation]
)
cell_reference_as_string

A cell reference, written as a string, delimited by quotation marks., e.g. “A2” or “B2:B5”

[optional] is_A1_notation

Indicates if the cell reference is in A1 notation (TRUE) or R1C1 notation (FALSE)

Examples

INDIRECT(A1) returns 10