INDIRECT Function in Excel
Learn how to use the INDIRECT function in Excel, understand the syntax and common use cases, and let ExcelGPT adapt the formula to your real workbook structure.
INDIRECT(ref_text, [a1])ref_textRequiredThe text string that Excel should interpret as a reference.
a1OptionalOptional TRUE for A1 style references or FALSE for R1C1 style.
Examples
=INDIRECT("'"&A2&"'!B2")Uses the sheet name stored in A2 to return the value from cell B2 on that sheet.
=SUM(INDIRECT("C2:C"&D2))Creates a variable SUM range ending at the row number stored in D2.
Common mistakes
Check the argument order, data types, and references used in INDIRECT.
Review whether ranges, blank cells, error values, or dynamic results are affecting the formula.
Validate the formula on a few sample rows before scaling it across the workbook.
Related functions
Need a variant of this formula?
Describe your workbook structure and ExcelGPT can generate a version tailored to your real columns, ranges, and edge cases.