INDIRECT
Returns the value of the reference specified by a text string.
Syntax
=INDIRECT(RefText, [R1C1Style])
Arguments
| Name | Description |
|---|---|
| RefText | A 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
| Formula | Result | Comment |
|---|---|---|
| 10 | Returns the value of cell A1 |
| 42 | Assuming that A5 contains the value 4 the result represents the value of cell A4 |