Please enable JavaScript to view the comments powered by Disqus.


Understanding INDIRECT() formula in  MS Excel

The indirect function is useful in the way that i indirectly read the addresses and return the reference specified by a text string. These references are spontaneously evaluated to display their contents. 

Used Functions

Category: Lookup and reference

Returns a reference indicated by a text value


INDIRECT(ref_text, [a1])

Lets chat on this