Skip to content
ExcelExcel 2024+

MAKEARRAY function in Excel

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

=MAKEARRAY(rows, cols, lambda(row, col))

MAKEARRAY syntax and parameters

Three arguments, three required.

  • rowsnumberRequired
  • colsnumberRequired
  • lambda(row, col)anyRequired

MAKEARRAY examples

Formulas you'll actually reuse.

  1. A 12×12 multiplication table from row and column indexes:

    =MAKEARRAY(12, 12, LAMBDA(r, c, r * c))

  2. A 5×3 grid with ones on the diagonal:

    =MAKEARRAY(5, 3, LAMBDA(r, c, IF(r = c, 1, 0)))

MAKEARRAY in Google Sheets

Same name — your formula ports as-is.

Try MAKEARRAY in the playground

Edit the example — nothing to install.

Preloaded with the MAKEARRAY formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.