Please enable JavaScript to view the comments powered by Disqus.


Using INDIRECT() function in MS Excel

The INDIRECT() function is used such that it 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