Quick Navigation
MAP Function
Summary
The MAP function transforms each element in one or more arrays by applying a custom LAMBDA function, returning a new array with the transformed values. Perfect for bulk data transformations without complex array formulas.
Syntax
=MAP(array1, lambda_or_array<#> )Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| array1 | Array |
Yes | Primary array to map/transform. Can be range, table column, or spilled array |
| lambda_or_array<#> | LAMBDA |
Yes | Custom LAMBDA function applied to each element. Must match number of input arrays |
Using the MAP Function
MAP is ideal for applying the same transformation to every item in an array. Use it to square numbers, categorize data, format values, or perform any repeatable calculation across datasets.
Common MAP Examples
Square Numbers Conditionally
=MAP(A1:C2, LAMBDA(a, IF(a>4,a*a,a)))Squares only numbers greater than 4, leaves smaller numbers unchanged. Spills results automatically.
Find Matching TRUE Pairs
=MAP(TableA[Col1],TableA[Col2],LAMBDA(a,b,AND(a,b)))Returns TRUE only for rows where both columns are TRUE. Works with Excel tables.
Multi-Condition Filter Helper
=FILTER(D2:E11,MAP(D2:D11,E2:E11,LAMBDA(s,c,AND(s="Large",c="Red"))))Combines MAP with FILTER to extract rows matching multiple criteria.
Frequently Asked Questions
Common Errors and Solutions
#VALUE! - Incorrect Parameters
Cause: LAMBDA doesn't match number of input arrays
Solution: Ensure LAMBDA has parameter for each array argument
#VALUE! - Array mismatch
Cause: Input arrays have different dimensions
Solution: All arrays must have identical size and shape
#NAME?
Cause: LAMBDA syntax error
Solution: Check LAMBDA spelling and parameter names
Notes
- Available only in Excel 365 and Excel 2021
- Returns dynamic array that spills automatically
- LAMBDA must be final argument
- Maximum performance with structured table references
- Combines powerfully with FILTER/SORT/UNIQUE
Compatibility
Available in: Excel 365, Excel 2021
Not available in: Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 365