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.
LogicalDynamic Arrays & LAMBDALogic & ConditionsModern Excel Functions
What it does
Transforms every value in an array using a custom LAMBDA function.
Syntax
MAP(array1, lambda)
Arguments
array1(array) — Array to map.lambda(function) — LAMBDA(value) to transform.
Examples
Check if Even
Map numbers to Even/Odd.
FORMULA
=MAP(A1:A3, LAMBDA(x, IF(ISEVEN(x), "Even", "Odd")))
RESULT
[Odd; Even; Odd]
SAMPLE DATA
| A | |
|---|---|
| 1 | Val |
| 2 | 1 |
| 3 | 2 |
| 4 | 3 |