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
Syntax
MAP(array1, [array2, ...], lambda)
Parameters
- array1: Required. An array to be mapped
- array2: Optional. Additional arrays to be mapped
- lambda: Required. A LAMBDA that must be the last argument and which takes parameters equal to the number of arrays passed
Example
=MAP(A1:A5, LAMBDA(x, x * 2))