INDIRECT(...)
How to read cell addresses with INDIRECT() function to return results.
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 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.