INDIRECT(...)
Using INDIRECT() function in MS Excel
Used Functions
Category: Lookup and reference
Returns a reference indicated by a text value
Syntax
INDIRECT(ref_text, [a1])
Practice INDIRECT Formula at Sheetzoom
INDIRECT formula at Microsoft help
0
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.