MAKEARRAY

MAKEARRAY(rows, cols, function)

Returns the array calculated by applying a LAMBDA function.

rows	The number of rows in the array.
cols	The number of columns in the array.
function	The LAMBDA function lambda(row, col)

REMARKS

* This function was added in Excel 2024.
* This function can create a Dynamic Array Formula.
* This function uses the LAMBDA function.
* This LAMBDA function must take two parameters.
* The Eta Reduced Lambda syntax cannot be used here because there are multiple arguments that need to be passed.
* The parameter names must not contain any numbers.
* The "row" is the row index of the array.
* The "column" is the column index of the array.
* If "row" < 1, then #VALUE! is returned.
* If "col" < 1, then #VALUE! is returned.
* This function was first released in July 2021.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A
1	=MAKEARRAY(1, 1, LAMBDA(p_one, p_two, p_one)) = 1
2	=MAKEARRAY(1, 1, LAMBDA(p_one, p_two, p_two)) = 1
3	=MAKEARRAY(1, 1, LAMBDA(p_one, p_two, p_one+p_two)) = 2
4	=MAKEARRAY(2, 2, LAMBDA(p_one, p_two, p_one*p_two)) = { 1, 2 ; 2, 4 }

1 - Create a 1x1 array using a formula that returns the row number.
2 - Create a 1x1 array using a formula that returns the column number.
3 - Create a 1x1 array using a formula that adds the row number and the column number together.
4 - Create a 2x2 array using a formula that multipies the row number and the column number together. The array that is returned is calculated from (1*1, 1*2 ; 2*1, 2*2).