Excel formula translator
Translator
Functions
Translation table
Error codes
Academy
🔍
Search functions
🌐 EN ▾
English
Deutsch
Français
Español
Português
☰
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 version
Available
Excel 2007
✗
Excel 2013
✗
Excel 2019
✗
Excel 2021
✗
Microsoft 365
✓
Translate a formula with this function
fx
EN
=MAKEARRAY(D2,E2,LAMBDA(row,col,CHOOSE(RANDBETWEEN(1,3),"Red","Blue","Green")))
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
AND
BYCOL
BYROW
FALSE
IF
IFERROR
IFNA
IFS
Copied to clipboard
↑
↓
·
Enter
·
Esc
Excel functions ›