Please enable JavaScript to view the comments powered by Disqus.


INDIRECT(...C13)

Using INDIRECT() function to read cell addresses and return corresponding values. 

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