MAP (array, lambda_or_array)

Returns the array formed by applying a map using a LAMBDA function.

arrayAn array to be mapped.
lambda_or_arrayA LAMBDA or array.


* Added in Microsoft 365 and is only available to Office Insiders at the moment.
* This function can return a Dynamic Array Formula.
* This function uses the LAMBDA function.
* The "lambda_or_array" must be the last argument and which must have either a parameter for each array passed, or another array to be mapped.
* This function was released in July 2021.
* For the Microsoft documentation refer to


© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top