Formulas > =MAKEARRAY()
How to Use MAKEARRAY() in Google Sheets
Description
How To Actually Use MAKEARRAY() in Sheets
MAKEARRAY(rows, columns, LAMBDA)
Try MAKEARRAY yourself
Use the MAKEARRAY function to create a 3x3 array in the range A1:C3, where each cell contains the sum of its row and column indices (starting from 1).
Hints (2)
-
Remember that row and column indices start at 1 in MAKEARRAY.
-
You can use LAMBDA to define how to calculate the values in the array.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the MAKEARRAY() formula:
Generate a MAKEARRAY() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses MAKEARRAY(). 2 free AI generations, no signup. Members get unlimited use.
Generate a MAKEARRAY() formula