Skip to main content
Version: Streamsheets 2.5

INDIRECT

Returns the value of the reference specified by a text string.

Syntax

=INDIRECT(RefText, [R1C1Style])

Arguments

NameDescription
RefTextA textual representation of a cell reference, cell range reference or a named cell.
R1C1Style (optional)If set to FALSE the given RefText is interpreted as R1C1-style reference. Default is TRUE.

Return

The value at specified reference or #REF! if reference could not be created. Referencing to an indirect() function will result in handing over the reference build with the indirect cell not handing over the value represented by indirect().

Examples

FormulaResultComment
=INDIRECT("A1")
10Returns the value of cell A1
=INDIRECT("A" & A5)
42Assuming that A5 contains the value 4 the result represents the value of cell A4