Menu
EXCEL MAKEARRAY FUNCTION
Excel MAKEARRAY Function Introduction
When called with a LAMBDA, this method produces a calculated array with the supplied row and column sizes.
Description of Excel MAKEARRAY Function
Syntax :
=MAKEARRAY(rows, cols, lambda(row, col))
Parameters :
- rows – The array’s number of rows. It is much more than just zero.
- cols – The array’s number of columns. It must be more than zero.
- lambda – A LAMBDA used to construct the array. The LAMBDA takes into account two factors:
- row – The array’s row index
- col – The array’s column index.
Step By Step Guide of MAKEARRAY Function
Example :
=MAKEARRAY(D2,E2,LAMBDA(row,col,CHOOSE(RANDBETWEEN(1,3),”Red”,”Blue”,”Green”)))
Key Points
Providing an incorrect LAMBDA function or the incorrect number of parameters results in a #VALUE! “Incorrect Parameters” is a mistake.
Setting a row or col parameter to 1 or a non-number causes a #VALUE! error.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
