This Excel tutorial explains how to use the INDIRECT function with syntax and examples.
Excel INDIRECT function Description
Microsoft Excel INDIRECT function returns the reference to a cell based on its string representation.
The INDIRECT function is a built-in function in Excel that is categorized as a Lookup/Reference Function that can be entered as part of a formula in a cell of a worksheet.
Explanation: Based on the example above, the INDIRECT function would return:
=INDIRECT("$B$4")
Result: 3
=INDIRECT("A5")
Result: 10570
=INDIRECT("A5", TRUE)
Result: 10570
=INDIRECT("R2C3", FALSE)
Result: $3.50
Syntax
The syntax for the INDIRECT function in Microsoft Excel is:
INDIRECT( string_reference, [ref_style] )
Arguments
- string_reference
- A textual representation of a cell reference.
- ref_style
- Optional. It is either a TRUE or FALSE value. TRUE indicates that string_reference will be interpreted as an A1-style reference. FALSE indicates that string_reference will be interpreted as an R1C1-style reference. If this parameter is omitted, it will interpret string_reference as an A1-style.
Returns
The INDIRECT function returns the reference to a cell and thus displays the referenced cell’s value.