Intro & Discussion
- INDIRECT, ADDRESS, ROW & COLUMN, OFFSET
- Prior LOOKUP functions: CHOOSE, VLOOKUP, INDEX, MATCH
- R1C1 referencing
- Problems of INDIRECT & OFFSET: volatile function, hard to audit
- R1C1 vs A1
- dynamic ranges, charts
INDIRECT
ADDRESS
Introduction to OFFSET
Solving Problems with OFFSET