MAKEARRAY(rows, cols, lambda(row, col))

Returns the array calculated by applying a LAMBDA function.

rowsThe number of rows in the array
Must be greater than zero.
colsThe number of columns in the array
Must be greater than zero.
lambdaA LAMBDA that is called to create the array.
rowThe row index of the array.
colThe column index of the array.


* Added in Microsoft 365 and is only available to Office Insiders at the moment.
* This function can return a Dynamic Array Formula.
* This function uses the LAMBDA function.
* This function was released in July 2021.
* For the Microsoft documentation refer to


© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top