Please enable JavaScript to view the comments powered by Disqus.


How to use Excel's INDIRECT() function

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