Please enable JavaScript to view the comments powered by Disqus.


INDIRECT(...C13)

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

Syntax

INDIRECT(ref_text, [a1])

Lets chat on this