1000 Excel Formulas
Home
Categories
About
Search
INDIRECT
Lookup
Returns a reference specified by a text string
Syntax:
=INDIRECT(ref_text, [a1])
Example:
=INDIRECT("A" & 1)