INDIRECT
Description
Returns a cell reference corresponding to the specified text string. This function is
volatile; it generates a new value any time any cell in the workbook changes.
Syntax
INDIRECT(
ref_text
, [
a1_ref_style_flag
])
- ref_text: The text describing the cell reference.
- a1_ref_style_flag: The cell reference style. TRUE or Empty = A1 style; this is the only style that Worksheets supports.
Example
The examples are based on this spreadsheet:
A | B | C | |
|---|---|---|---|
1
| 4 | 6 | 12 |
2
| 8 | 10 | 18 |
3
| 14 | 22 | 26 |
Formula | Result |
|---|---|
=INDIRECT("C2") | 18 |
=GCD(INDIRECT("A1:"&ADDRESS(1,3))) | 2 |
Notes
- The function doesn't run as a volatile function if the Worksheets calculation mode is set toManualin .
- If the reference text attempts to reference a cell on a different sheet, Worksheets returns aninvalid cell referenceerror.