INDIRECT
Returns the value of the reference specified by a text string.
Syntax
=INDIRECT(RefText, [R1C1Style])
Arguments
| Name | Type | Description |
|---|---|---|
| RefText | String | A textual representation of a cell reference, cell range reference or a named cell. |
| R1C1Style (optional) | Boolean | If set to FALSE the given RefText is interpreted as R1C1-style reference. Default value: TRUE |
Return
| Type | Description |
|---|---|
| Number | 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 |