Home › Functions › Logical › MAKEARRAY
fx
MAKEARRAY
Logical  ·  Since: Microsoft 365  ·  9 languages

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

🌐 Translations

English MAKEARRAY
Deutsch MAKEARRAY
Français MAKEARRAY
Español MAKEARRAY
Italiano CREAMATRICE
Português MAKEARRAY
Nederlands MAKEARRAY
Polski MAKEARRAY
Русский MAKEARRAY

📦 Availability

Excel versionAvailable
Excel 2007 ✗
Excel 2013 ✗
Excel 2019 ✗
Excel 2021 ✗
Microsoft 365 ✓
Translate a formula with this function
fx EN
fx DE

⌨ Syntax

MAKEARRAY(rows,cols,function)

Arguments

rows (required)
cols (required)
function (required)

▶ Examples

=MAKEARRAY(D2,E2,LAMBDA(row,col,CHOOSE(RANDBETWEEN(1,3),"Red","Blue","Green")))
=MAKEARRAY(3,3,LAMBDA(r,c,r*c))
=MAKEARRAY(rows,cols,lambda(row,col))

Related functions

Copied to clipboard