# Excel MAKEARRAY Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/excel/makearray-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 MAKEARRAY function generates dynamic arrays by defining rows, columns, and custom calculations using lambda functions. ```excel =MAKEARRAY(rows, columns, lambda) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the MAKEARRAY you need in plain EnglishGenerate Formula Need more than a single MAKEARRAY formula? Try our free [AI for Excel](https://betteranalyst.com/excel-ai) — it reads your entire spreadsheet, answers questions in plain English, and builds charts and analysis in the same chat. ## Parameters **`rows`**:\ The number of rows that the resulting array will have. **`columns`**:\ The number of columns that the resulting array will have. **`lambda`**:\ A LAMBDA function that defines the operation to perform on each element of the array, taking the row and column indices as parameters. ## What is a MAKEARRAY Formula in Excel? The *MAKEARRAY* function in Excel is a versatile tool that allows you to create an array of values based on a specified formula. It generates a two-dimensional array by applying a function to each element of the specified dimensions, making it a powerful feature for dynamic array calculations. In simpler terms, the MAKEARRAY function helps you generate a grid of values based on a formula, enabling complex calculations and data manipulations in a structured format. ## A Practical Example Imagine you want to create a multiplication table for the numbers 1 through 5 in an Excel spreadsheet. ### Multiplication Table: | | 1 | 2 | 3 | 4 | 5 | | - | - | - | - | - | - | | 1 | | | | | | | 2 | | | | | | | 3 | | | | | | | 4 | | | | | | | 5 | | | | | | You want to fill this table with the product of the row and column numbers. ## MAKEARRAY Formula To create the multiplication table, you would use the MAKEARRAY formula as follows: ```excel =MAKEARRAY(5, 5, LAMBDA(r, c, r * c)) ``` ### Breakdown of the Formula: - **5**: This is the number of rows in the array. - **5**: This is the number of columns in the array. - **LAMBDA(r, c, r \* c)**: This is the function that defines how to calculate each element in the array, where `r` is the row number and `c` is the column number. ## Result of the Formula When you apply the formula, it generates a multiplication table as follows: | | 1 | 2 | 3 | 4 | 5 | | - | - | - | - | - | - | | 1 | 1 | 2 | 3 | 4 | 5 | | 2 | 2 | 4 | 6 | 8 | 10 | | 3 | 3 | 6 | 9 | 12 | 15 | | 4 | 4 | 8 | 12 | 16 | 20 | | 5 | 5 | 10 | 15 | 20 | 25 | Here, each cell is filled with the product of its row and column indices. ## Why Use MAKEARRAY? The MAKEARRAY function is particularly useful when you need to generate complex arrays or perform calculations that require a structured output. It allows you to create dynamic arrays without manually entering data, making it easier to visualize and analyze results. ## Key Takeaways: - **MAKEARRAY**: Creates a two-dimensional array based on a specified formula. - **Dynamic Calculations**: Enables complex calculations in a structured format. - **Common Use Cases**: Ideal for generating tables, performing matrix operations, and any scenario where you need to create arrays based on formulas. Understanding how to use the MAKEARRAY function can significantly enhance your data manipulation capabilities in Excel, allowing you to create dynamic and insightful datasets. Happy calculating! ## Example use case You have a table where Column A contains the names of products and Column B contains their corresponding prices. You can use the MAKEARRAY function to create a new array that generates a grid of product names paired with their prices in a structured format. This allows for easy visualization of product offerings and pricing, facilitating better inventory management and sales presentations without the need for manual data entry or complex formatting. **Beyond the MAKEARRAY function:** Better Analyst is a full [Excel AI](https://betteranalyst.com/excel-ai) that goes well past individual formulas. Upload any spreadsheet and ask questions in plain English — you'll get formulas, data analysis, and charts back in seconds. It's a free [AI Excel assistant](https://betteranalyst.com/excel-ai) that works with any .xlsx, .xls, or .csv file — no plugins, no Microsoft 365 required. Don't have a spreadsheet yet? Use our free [AI spreadsheet generator](https://betteranalyst.com/ai-excel-spreadsheet-generator) to turn a text prompt into a downloadable Excel file — a full [AI Excel sheet maker](https://betteranalyst.com/ai-excel-spreadsheet-generator) that builds headers, columns, and formulas from your description. ## Need more help with Excel formulas? Create a free account for formula help, explanations, and spreadsheet analysis. Usage limits depend on your plan. [Create Free Account](https://betteranalyst.com/signup)[Try Formula Generator](https://betteranalyst.com/excel-ai) ## Excel how-to guides - [How To Lock Cells In Excel](https://betteranalyst.com/excel/how-to-lock-cells-in-excel) - [How To Make A Copy Of An Excel Sheet](https://betteranalyst.com/excel/how-to-make-a-copy-of-an-excel-sheet) - [How To Make A Graph In Excel](https://betteranalyst.com/excel/how-to-make-a-graph-in-excel) - [How To Make A Histogram In Excel](https://betteranalyst.com/excel/how-to-make-a-histogram-in-excel) - [How To Make A Line Graph In Excel](https://betteranalyst.com/excel/how-to-make-a-line-graph-in-excel) - [How To Make A Pie Chart In Excel](https://betteranalyst.com/excel/how-to-make-a-pie-chart-in-excel) - [How To Make A Table In Excel](https://betteranalyst.com/excel/how-to-make-a-table-in-excel) - [How To Merge Cells In Excel](https://betteranalyst.com/excel/how-to-merge-cells-in-excel) ## Explore all Excel formulas Browse our complete library of Excel 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.