Excel functions / Logical

MAKEARRAY function

Builds an array of a set size, working out each cell from its row and column number.

Syntax

=MAKEARRAY(rows, columns, lambda)

Arguments

When to use it

MAKEARRAY builds an array of a given number of rows and columns, working out each cell with a LAMBDA that is given its row and column number. Times tables, calendars and test grids come out of one formula.

Examples

  1. A times table

    ABC
    1Table
    2123
    3246
    4369

    In A2: =MAKEARRAY(3, 3, LAMBDA(r, c, r*c)) → 1, 2, 3; 2, 4, 6; 3, 6, 9

    Try this example

Common mistakes

Try MAKEARRAY in the playground

Related functions