INDIRECT Formula Generator
INDIRECT converts a text string into a cell reference. This lets you build dynamic references — change which sheet, column, or range a formula refers to based on other cell values.
Syntax
=INDIRECT(ref_text, [a1])Try it — generate a INDIRECT formula
Examples
Reference from another sheet dynamically
=INDIRECT("'"&A1&"'!B2")If A1 contains "January", this reads B2 from the January sheet.
Dynamic column reference
=SUM(INDIRECT("B2:B"&ROW(B100)))Creates a dynamic sum range that can be modified by changing the column letter or end row.
Tips
- ✓INDIRECT is volatile — it recalculates every time the sheet changes, which can slow large workbooks.
- ✓Use single quotes around sheet names with spaces: "'"&A1&"'!A1".
- ✓Combine with MATCH or ROW for powerful dynamic range references.
Related Formulas
XLOOKUP
XLOOKUP is the modern replacement for VLOOKUP and HLOOKUP. It can search in any ...
INDEX-MATCH
INDEX-MATCH is a powerful combination that can look up values in any direction —...
Data Validation Formulas
Data validation formulas control what users can enter in cells. Create dependent...
Need a different formula?
Describe any formula in plain English and FormulaPad will generate it.
Try FormulaPad Free