INDIRECT
Returns a reference indicated by a text value.
Lookup & ReferenceLookup & Matching Essentials
What it does
Returns a valid reference from a text string (e.g., "A1" string becomes A1 reference).
Syntax
INDIRECT(ref_text, [a1])
Arguments
ref_text(text) — Reference as text (e.g., "Sheet1!A5").a1(logical) — TRUE=A1 style, FALSE=R1C1 style.
Examples
Dynamic Reference
Reference cell named in A1.
FORMULA
=INDIRECT(A1)
RESULT
100
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Ref | Value |
| 2 | B1 | 100 |