Applies a LAMBDA to each element of an array and returns the results as an array of the same shape.

Syntax

=MAP(array1, [array2], ..., lambda)

• Transform each element

  =MAP({1,2,3},LAMBDA(x,x*10)) → {10,20,30}

  Each element times ten.

• Per-cell calculation

  =MAP(A2:A6,LAMBDA(p,LEN(p))) → {6;6;5;9;10}

  The length of each product name.

• Two arrays

  =MAP(A2:A6,B2:B6,LAMBDA(a,b,a&": "&b)) → {Widget: 10; …}

  Two arrays, one LAMBDA with two parameters.

• Use it when a function does not naturally work on arrays, such as some text functions.
• Arrays must be the same size.
• Returns one value per element; use BYROW for one value per row.

• #VALUE! when arrays differ in size.
• Requires Microsoft 365.