INDIRECT formula returns the reference to a cell or range on the base of its string representation.
Syntax for INDIRECT formula
INDIRECT(ref_text, [a1] )
Parameters Details:
- ref_text: A textual representation of a cell reference.
- a1: 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 formula returns the reference to a cell or range.
