Functions
INDIRECT
Returns the value referenced by a cell address string
When to use it
When should I use INDIRECT?
Use INDIRECT to convert a text string into a live cell reference at evaluation time — essential when the target address is built dynamically from other cells or formulas.
Used in
Syntax
INDIRECT(ref_text, [a1])