Please enable JavaScript to view the comments powered by Disqus.


How to read R1C1 style referencing with INDIRECT() function

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