MAP function
Summary
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<#>)
The MAP function syntax has the following arguments and parameters:
• 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.
• 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.
Example
=MAP(A1:C2, LAMBDA(a, IF(a>4,a*a,a)))
=MAP(TableA[Col1],TableA[Col2],LAMBDA(a,b,AND(a,b)))
=FILTER(D2:E11,MAP(D2:D11,E2:E11,LAMBDA(s,c,AND(s="Large",c="Red"))))
=MAP(TableA[Col1],TableA[Col2],LAMBDA(a,b,AND(a,b)))
=FILTER(D2:E11,MAP(D2:D11,E2:E11,LAMBDA(s,c,AND(s="Large",c="Red"))))