Please enable JavaScript to view the comments powered by Disqus.


INDIRECT(...C13,FALSE)

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

Syntax

INDIRECT(ref_text, [a1])

Lets chat on this