Skip to content
ExcelExcel 2024+

MAP function in Excel

Returns an array formed by mapping each value in the array(s) to a new value by applying a LAMBDA to create a new value

=MAP(array1, lambda_or_array<#>)

MAP syntax and parameters

Two arguments, two required.

  • array1arrayRequired
  • lambda_or_array<#>anyRequired

MAP examples

Formulas you'll actually reuse.

  1. Gross amounts from a net column, without a helper column:

    =MAP(D2:D200, LAMBDA(amount, ROUND(amount * 1.19, 2)))

  2. Two arrays at once — quantity times unit price per row:

    =MAP(C2:C200, D2:D200, LAMBDA(qty, price, qty * price))

MAP in Google Sheets

Same name — your formula ports as-is.

Try MAP in the playground

Edit the example — nothing to install.

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

Loading the editor…

Related functions

More ways Excel gets this done.