INDIRECT(...)
Using INDIRECT() excel function to read R1C1 type cell references.
Used Functions
Category: Lookup and reference
Returns a reference indicated by a text value
Syntax
INDIRECT(ref_text, [a1])
Practice INDIRECT Formula at Sheetzoom
INDIRECT formula at Microsoft help
0
The indirect function is useful in the way that it returns reference to range. These references are spontaneously evaluated to display their contents. We can use either A1 or R1C1 style of referencing with INDIRECT() function.