FUNCTION CATALOGUE / LOGICAL / ARRAY
MAKEARRAY Excel function
Creates an array using a LAMBDA.
Correct sentence to use
Create an array with [rows] rows and [columns] columns using [calculation].
Modify this query in PlainFormula →Example formula
=MAKEARRAY(3,3,LAMBDA(r,c,r*c))
Generates an array using row and column indexes.
Syntax
MAKEARRAY(rows, cols, lambda)
Argument signature: rows, cols, lambda
Availability note
Available in supported Microsoft 365 / newer Excel versions; verify the exact release and platform.