FUNCTION CATALOGUE / LOGICAL / ARRAY
MAP Excel function
Applies a LAMBDA to each value in an array.
Correct sentence to use
Apply [calculation] to every value in [array].
Modify this query in PlainFormula →Example formula
=MAP(A2:A10,LAMBDA(x,x*2))
Maps a LAMBDA across array values.
Syntax
MAP(array1, lambda_or_array2, …)
Argument signature: array1, lambda_or_array2, …
Availability note
Available in supported Microsoft 365 / newer Excel versions; verify the exact release and platform.