# Google Sheets ADDRESS Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/address-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 ADDRESS function returns the cell reference as a text string based on specified row and column numbers in Google Sheets. ``` ADDRESS(row, column, [absolute_relative_mode], [use_a1_notation], [sheet]) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the ADDRESS you need in plain EnglishGenerate Formula ## Parameters **`row`**:\ The row number of the cell reference you want to create. This is a required parameter. **`column`**:\ The column number of the cell reference you want to create. This is a required parameter. **`absolute_relative_mode`**:\ A number that specifies the type of reference to return: 1 for absolute (e.g., $A$1), 2 for absolute row and relative column (e.g., A$1), 3 for relative row and absolute column (e.g., $A1), and 4 for relative (e.g., A1). This is an optional parameter. **`use_a1_notation`**:\ A boolean value that specifies whether to use A1 notation (TRUE) or R1C1 notation (FALSE). This is an optional parameter. **`sheet`**:\ The name of the sheet to use for the cell reference. This is an optional parameter. ## What is the ADDRESS Function? The *ADDRESS* function in Google Sheets is a useful tool that returns the cell reference as a text string based on a given row and column number. This function can be particularly helpful when you need to create dynamic cell references in your formulas or when you want to display the address of a specific cell in your spreadsheet. In simpler terms, ADDRESS allows you to convert row and column numbers into a cell reference, making it easier to work with dynamic ranges in your data. ## A Practical Example Imagine you are working with a simple sales report where you want to reference specific cells based on their row and column numbers. ### Sales Report Table: | Row | Product | Sales | | - | - | - | | 1 | Widget A | 100 | | 2 | Widget B | 150 | | 3 | Widget C | 200 | You want to find the address of the cell that contains the sales figure for Widget B. ## ADDRESS Formula To achieve this, you would use the ADDRESS function as follows: ``` =ADDRESS(2, 3) ``` In this formula: - `2` is the row number where Widget B's sales figure is located. - `3` is the column number that corresponds to the Sales column. ## Result of the Formula When you apply the ADDRESS formula, the output would be: ``` C2 ``` This indicates that the sales figure for Widget B is located in cell C2. ## Why Use ADDRESS? ADDRESS is beneficial because it allows you to create dynamic references in your spreadsheets. This can be particularly useful in scenarios where you want to reference cells based on calculations or user inputs. By using ADDRESS, you can avoid hardcoding cell references, making your formulas more flexible and easier to maintain. ## Key Takeaways: - **ADDRESS**: A function that converts row and column numbers into a cell reference as a text string. - **Dynamic References**: Ideal for creating references based on calculations or user inputs. - **Flexibility**: Helps avoid hardcoding cell references, making formulas easier to manage. - **Common Use Cases**: Useful in reporting, data analysis, and any scenario where dynamic cell referencing is needed. The ADDRESS function is a valuable tool for anyone working with data in Google Sheets, providing a straightforward way to enhance your spreadsheet functionality. Happy spreadsheeting! ## Example use case You have a sales report where Column A lists product names and Column B contains their sales figures. Use the ADDRESS formula to dynamically reference the cell of a specific product's sales data based on its row number, enabling quick access to performance metrics. ## 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 Filter In Google Sheets](https://betteranalyst.com/google-sheets/how-to-filter-in-google-sheets) - [How To Find Circular References In Google Sheets](https://betteranalyst.com/google-sheets/how-to-find-circular-references-in-google-sheets) - [How To Find Duplicates In Google Sheets](https://betteranalyst.com/google-sheets/how-to-find-duplicates-in-google-sheets) - [How To Freeze A Row In Google Sheets](https://betteranalyst.com/google-sheets/how-to-freeze-a-row-in-google-sheets) - [How To Freeze Panes In Google Sheets](https://betteranalyst.com/google-sheets/how-to-freeze-panes-in-google-sheets) - [How To Highlight Duplicates In Google Sheets](https://betteranalyst.com/google-sheets/how-to-highlight-duplicates-in-google-sheets) - [How To Insert Checkbox In Google Sheets](https://betteranalyst.com/google-sheets/how-to-insert-checkbox-in-google-sheets) - [How To Insert Multiple Rows In Google Sheets](https://betteranalyst.com/google-sheets/how-to-insert-multiple-rows-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.