Returns a calculated array of a specified row and column size, by applying a LAMBDA.

## Syntax

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

The MAKEARRAY function syntax has the following arguments and parameters:

• rows      The number of rows in the array. Must be greater than zero.

• cols      The number of columns in the array. Must be greater than zero.

• lambda       A LAMBDA that is called to create the array. The LAMBDA takes two parameters:

• row      The row index of the array.

• col      The column index of the array.

## Errors

Providing an invalid LAMBDA function or an incorrect number of parameters returns a #VALUE! error called "Incorrect Parameters".

Setting a row or col argument to a value < 1 or to a non-number returns a #VALUE! error.

## Examples

Example 1: Create a 2D array representing a simple multiplication table

Copy the following formula into cell C2:

=MAKEARRAY(3, 3, LAMBDA(r,c, r*c))

Example 2: Create a random list of values

Enter the sample data into cells D1:E3, and then copy the formula into cell D4:

=MAKEARRAY(D2,E2,LAMBDA(row,col,CHOOSE(RANDBETWEEN(1,3),"Red","Blue","Green")))