MAKEARRAY

Creates array from lambda over indices.

Excel: Verified match
Google Sheets: Verified match
Returns: Array

Examples

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

Result 1

Syntax

MAKEARRAY(rows, columns, lambda)

rows: number required
columns: number required
lambda: any required

Errors

#ERROR!: =MAKEARRAY(3, 3)
#VALUE!: =MAKEARRAY(3, 0, LAMBDA(x, y, y))

ARRAY_CONSTRAINTruncates a range to at most the given rows and columns. ARRAYFORMULAEvaluates an expression across a range (this engine already spills, so it is a pass-through for sheets compatibility). ARRAYTOTEXTConverts array to text representation. BYCOLApplies lambda to each column of array. BYROWApplies lambda to each row of array. CHOOSECOLSReturns the specified columns from an array.