Logical Excel 365 ◉ 4 views Dynamic Array

=MAP()

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

Applies To: Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for Mac

=MAP (array1, lambda_or_array<#>)

Hover argument names in the table for details.

Output typeArray

Popularity30 / 100

VolatileNo

Dynamic ArrayYes

📥 Download sample .xlsx — Coming soon ▦ Try in Playground Dedicated file for this function — safe & lightweight · sample data + live formulas

⬇ Download Sample Workbook

A dedicated .xlsx for =MAP() with Persian sample data & live formulas — open in Excel and practice.

📥 Download MAP.xlsx — Coming soon ~ 8–12 KB · No macros

%d questions — syntax, example & errors — test yourself!

Start quiz →

Argument	Type	Required	Description
`array1`	Array	Optional	An array to be mapped.
`lambda_or_array`	Range	Optional	<#> A LAMBDA which must be the last argument and which must have either a parameter for each array passed, or another array to be mapped.

Example 1 =MAP(B2:B20, LAMBDA(x, IF(x > 1000, x * 1.09, x)))

Example 2 =MAP(B2:B20, C2:C20, LAMBDA(a, b, MAX(a, b)))

#VALUE! Providing an invalid LAMBDA function or an incorrect number of parameters returns a #VALUE! error called "Incorrect Parameters".