Formulas and Functions
The MAP function maps each value in an array to a new value determined by a LAMBDA function and returns a new array.
MAP(array, array…, LAMBDA(element, calculation))
array: The array to be mapped.
array…: An additional input array.
LAMBDA: A defined subformula.
element: An input that defines the value you are passing through the formula.
calculation: The formula you want the function to execute and return. This is required and must be the last argument.
Notes
You can use the spilled range operator “#” to reference an array created by a formula.
Example |
|---|
Given the following table: |
=MAP(A1:C2, LAMBDA(element, element^2)) returns the array below.
Thanks for your feedback.