ExcelFlux

MAKEARRAY function

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

Logical · Excel 2024+ · Guided Excel example

Where can you use it?

Teams building reports and business rules. Adapt the example’s decision rule when you need to test a condition or display different results based on it.

Scenario in the workbook

Generate a small multiplication table. Its diagonal contains the first three squares.

A worked example from the workbook

RowABC
6ValuePositionReading
7114
8429
97314
Record 1
=INDEX(MAKEARRAY(3,3,LAMBDA(row_num,col_num,row_num*col_num)),B7,B7)

Illustrative output1

See the inputs and instructions for all 3 examples

Worked examples

Generate a small multiplication table. Its diagonal contains the first three squares.

Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.

Row A B C
6 Value Position Reading
7 1 1 4
8 4 2 9
9 7 3 14
Trial Expression Sample output
Record 1 =INDEX(MAKEARRAY(3,3,LAMBDA(row_num,col_num,row_num*col_num)),B7,B7) 1
Record 2 =INDEX(MAKEARRAY(3,3,LAMBDA(row_num,col_num,row_num*col_num)),B8,B8) 4
Record 3 =INDEX(MAKEARRAY(3,3,LAMBDA(row_num,col_num,row_num*col_num)),B9,B9) 9
Microsoft Excel reference