INDIRECT
Returns the reference specified by a text string.
| Category | Lookup |
| Syntax | INDIRECT(ref_text, [a1]) |
Parameters
| Parameter | Required | Description |
|---|---|---|
ref_text | Required | A reference to a cell that contains an A1-style reference, an R1C1-style reference, or a named range. |
a1 | Optional | If TRUE (default), ref_text is A1-style. If FALSE, R1C1-style. |
Example
INDIRECT(value, range, col)
Auto-generated from the EngCanvas function registry.