# Google Sheets INDIRECT Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/indirect-function - Author: Better Analyst Formula Bot is now Better Analyst—same account, more powerful analysis.Formula Bot is now Better Analyst—same account and workflows, with more powerful analysis, dashboards, and automation. [Learn what changed](https://betteranalyst.com/formula-bot-is-now-better-analyst) The INDIRECT function returns the value of a cell specified by a text string, allowing dynamic cell references in formulas. ``` INDIRECT(cell_reference_as_string, [is_A1_notation]) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the INDIRECT you need in plain EnglishGenerate Formula ## Parameters **`cell_reference_as_string`**:\ A string that represents the cell reference or range of cells you want to refer to. This can be a single cell (e.g., "A1") or a range (e.g., "A1:B2"). **`is_A1_notation`**:\ An optional boolean value that specifies whether the `cell_reference_as_string` is in A1 notation (TRUE) or R1C1 notation (FALSE). If omitted, it defaults to TRUE. ## What is an INDIRECT Function? The *INDIRECT* function in Google Sheets is a powerful tool that allows you to reference a cell or range of cells indirectly. This means that instead of directly specifying the cell reference, you can use a text string to create a reference. This can be particularly useful when you want to create dynamic references that change based on other cell values. In simpler terms, INDIRECT allows you to build references to cells or ranges in a flexible way, making your formulas more adaptable to changes in your data. ## A Practical Example Imagine you are managing a sales report where you have monthly sales data stored in different sheets: ### January Sales Table: | ProductID | ProductName | Sales | | - | - | - | | 101 | Widget A | 500 | | 102 | Widget B | 300 | ### February Sales Table: | ProductID | ProductName | Sales | | - | - | - | | 101 | Widget A | 600 | | 102 | Widget B | 400 | You want to create a summary table that dynamically pulls the sales data for each month based on the month selected in another cell. ## INDIRECT Formula To achieve this, you would use the INDIRECT function as follows: ``` =INDIRECT(A1 & "!C2") ``` In this formula: - `A1` is the cell containing the name of the month (e.g., "January" or "February"). - `"!C2"` specifies the cell reference you want to pull data from (in this case, the Sales for ProductID 101). - The combination of `A1 & "!C2"` creates a dynamic reference to the correct cell based on the month selected. ## Result of the Formula When you apply the INDIRECT formula to your summary table, the output would look like this: | Month | ProductID | Sales | | - | - | - | | January | 101 | 500 | | February | 101 | 600 | If you change the value in cell A1 to "February", the INDIRECT function will automatically update the sales figure for ProductID 101 to reflect the February sales. ## Why Use INDIRECT? INDIRECT is beneficial because it allows for greater flexibility in your formulas. It enables you to create references that can change based on user input or other cell values, making your spreadsheets more dynamic. Additionally, it can help simplify complex formulas by breaking them down into manageable parts. ## Key Takeaways: - **INDIRECT**: A versatile function that allows you to reference cells or ranges indirectly using text strings. - **Dynamic References**: Enables the creation of references that can change based on other cell values, enhancing flexibility. - **Simplifies Formulas**: Helps to manage complex formulas by allowing you to break down references into simpler components. - **Common Use Cases**: Ideal for summary reports, dynamic dashboards, and any scenario where data needs to be pulled from different sheets or ranges based on user input. INDIRECT is an essential function for anyone working with data in Google Sheets, providing a powerful way to enhance data analysis and reporting capabilities. Happy spreadsheeting! ## Example use case You have a summary sheet where you want to reference specific data from multiple monthly sheets. By using the INDIRECT formula, you can dynamically pull values based on the month selected in a dropdown, ensuring your summary updates automatically with the chosen month. ## Need more help with Google Sheets formulas? Sign up for Better Analyst and get unlimited AI-powered formula generation, explanations, and advanced data analysis. [Create Free Account](https://betteranalyst.com/signup)[Try Formula Generator](https://betteranalyst.com/excel-ai) ## Google Sheets how-to guides - [How To Wrap Text In Google Sheets](https://betteranalyst.com/google-sheets/how-to-wrap-text-in-google-sheets) - [Google Sheets Conditional Formatting](https://betteranalyst.com/google-sheets/google-sheets-conditional-formatting) - [How To Add A Column In Google Sheets](https://betteranalyst.com/google-sheets/how-to-add-a-column-in-google-sheets) - [How To Alphabetize In Google Sheets](https://betteranalyst.com/google-sheets/how-to-alphabetize-in-google-sheets) - [How To Autofit In Google Sheets](https://betteranalyst.com/google-sheets/how-to-autofit-in-google-sheets) - [How To Calculate Percentage In Google Sheets](https://betteranalyst.com/google-sheets/how-to-calculate-percentage-in-google-sheets) - [How To Combine Two Columns In Google Sheets](https://betteranalyst.com/google-sheets/how-to-combine-two-columns-in-google-sheets) - [How To Copy Formula In Google Sheets](https://betteranalyst.com/google-sheets/how-to-copy-formula-in-google-sheets) ## Explore all Google Sheets formulas Browse our complete library of Google Sheets formula guides Compare your options ## Decide with evidence, not a sales pitch. Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose. 1. [01ChatGPTOpen a balanced comparison prompt in ChatGPT.](https://chatgpt.com/?prompt=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 2. [02ClaudeOpen the same research prompt in Claude.](https://claude.ai/new?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 3. [03PerplexityResearch the comparison with linked web sources.](https://www.perplexity.ai/search?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.