[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
INDIRECT ( ref-text [ , [ A1-ref-style-flag ] ] )
Description: Locates the reference specified by ref-text and evaluates that reference to get to its underlying value. [Note: This function should be used when the reference to a cell within a formula is to be changed without changing the formula itself. end note]
Arguments:
|
Name |
Type |
Description |
|
ref-text |
An A1-style reference, an R1C1-style reference, a name defined as a reference, or a reference to a cell as a string. |
If ref-text refers to another workbook (i.e., it's an external reference), that other workbook shall be open. |
|
A1-ref-style-flag |
logical |
Specifies the kind of reference that is contained in the cell ref-text. If TRUE or omitted, ref-text is interpreted as an A1-style reference (§3.17.2.3.1); otherwise, ref-text is interpreted as an R1C1-style reference (§3.17.2.3.2). |
Return Type and Value: any – The underlying value of the location referred to by ref-text.
However, if
• ref-text is not a valid cell reference, #REF! is returned.
• ref-text refers to another workbook yet that other workbook is not currently open, the return value is unspecified.
[Example:
Given the following data:
|
|
A |
B |
|
1 |
Data |
Data |
|
2 |
B2 |
1.333 |
|
3 |
B3 |
45 |
|
4 |
George | |
|
5 |
5 |
62 |
where A2 contains a reference to B2, A3 contains a reference to B3, A4 contains the defined name George that refers to B4, and A5 contains the row number of B5:
INDIRECT($A$2) results in 1.333
INDIRECT($A$3) results in 45
INDIRECT($A$4) results in 10
INDIRECT("B"&$A$5) results in 62
INDIRECT("R[-1]C",FALSE) uses the cell in the previous row and current column.
end example]