This function 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<#>)
This function has the following arguments:
| Argument | Description |
|---|---|
| array1 | An array to be mapped. |
| lambda_or_array<#> |
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. |
If an invalid LAMBDA function or an incorrect number of parameters are provided, it returns a #VALUE! error called "Incorrect Parameters".
Accepts an array and LAMBDA. Returns an array.
MAP(A1:C2, LAMBDA(a, IF(a>4,a*a,+a)))
MAP(TableA[Col1],TableA[Col2],LAMBDA(a,b,AND(a,b)))
This function is available in product version 15 or later.
