MAP

MAP(array, lambda_or_array2)

Returns the array formed by mapping each value to a new value using a LAMBDA function.

array	The array to be mapped.
lambda_or_array2	The LAMBDA function must be the last argument.

REMARKS

* This function was added in Excel 2024.
* This function can create a Dynamic Array Formula.
* This function uses the LAMBDA function.
* The Eta Reduced Lambda syntax cannot be used here.
* The LAMBDA function must be the last argument.
* The LAMBDA function must have a parameter for each array.
* You can use the BYCOL function to return the results from applying a LAMBDA function to each column in an array.
* You can use the BYROW function to return the results from applying a LAMBDA function to each row in an array.
* You can use the REDUCE function to return a single value after applying a LAMBDA function to an array.
* You can use the SCAN function to return an identical array by applying a LAMBDA function to return some intermediate calculation values.
* You can use the SORT function to return the array of data that has been sorted by one column.
* This function was first released in July 2021.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=MAP(10, LAMBDA(p_one, IF(p_one>5, p_one*p_one, p_one))) = 100
2	=MAP(5, LAMBDA(p_one, IF(p_one>5, p_one*p_one, p_one))) = 5
3	=MAP({5,10},LAMBDA(p_one,IF(p_one>5, p_one*p_one, p_one))) = {5,100}

1 - We would like to square all the numbers in the array that are greater than 5.
2 - We would like to square all the numbers in the array that are greater than 5.
3 - We would like to square all the numbers in the array that are greater than 5.