Please enable JavaScript to view the comments powered by Disqus.


Using INDIRECT() excel function to read R1C1 type cell references. 

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. 

Used Functions

Category: Lookup and reference

Returns a reference indicated by a text value


INDIRECT(ref_text, [a1])

Lets chat on this