What is INDIRECT?
Returns the reference specified by a text string. Enables dynamic references that can change based on cell values.
Syntax
=INDIRECT(ref_text, [a1])
Example
Formula: =INDIRECT(\
Result: Value from dynamic cell
How It Works
Converts text to a cell reference. If B1 contains 5, returns value from A5. Powerful for creating dynamic formulas that reference different ranges.