MAKEARRAY

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

Syntax

MAKEARRAY(rows; columns; lambda(row; column; calculation))

rows: The number of rows to create in result array. Eg., 2

columns: The number of columns to create in the result array. Eg., 3

lambda: The function to be applied to the given values.

row: A variable indicating sequential values. Eg., a

column: A variable indicating sequential values. Eg., b

calculation: The calculation to be applied to the given values. Eg., a*b

Examples

Formula

=MAKEARRAY(2;3;LAMBDA(a;b;a*b))

=MAKEARRAY(3;3;LAMBDA(a;b;a*b/2))

Get a hands-on experience of the function in the embedded range below.

Possible Errors

Errors	Meaning
#NAME!	The function name is incorrect or invalid. The given defined name (if any) is invalid. There is a typo in the defined name used in the function. Double quotes are missing for text values in the function. Colon missing in a cell range reference.
#VALUE!	The given argument's data type is incorrect or invalid.
#REF!	The given cell reference is incorrect or invalid. This error may occur when a cell/range has been deleted, moved, or pasted over.
#NUM!	The given array is too large.

Similar Functions

MAKEARRAY function - Zoho Sheet - Help Guide