MAP

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.

Syntax

MAP(array1, lambda_or_array<#>)

Argument	Description
array1	[Required] An array to be mapped.
lambda_or_array<#>	[Required] 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.

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

MAP(A1:C2, LAMBDA(a, IF(a>4,a*a,a)))