MAP Function

Description

Apply a LAMBDA function/expression to each value from given array and return results.

NOTE

• The function will return a #VALUE! when you providing an invalid LAMBDA function/expression.
• The input arrays should be the same size.

Syntax

Copied!=MAP(array1, [array2], ..., LAMBDA)
=MAP(array1, [array2], ..., LAMBDA)

EXAMPLE

Copied!//𝘶𝘴𝘦 𝘸𝘪𝘵𝘩 𝘯𝘢𝘵𝘪𝘷𝘦 𝘭𝘢𝘮𝘣𝘥𝘢  𝘰𝘳 𝘯𝘢𝘮𝘦𝘥 𝘭𝘢𝘮𝘣𝘥𝘢 𝘧𝘶𝘯𝘤𝘵𝘪𝘰𝘯
=MAP(A1:A10, ABS)
=MAP(A1:A10, LAMBDA(a, 2*a))
//𝘢𝘱𝘱𝘭𝘺 𝘭𝘢𝘮𝘣𝘥𝘢 𝘦𝘹𝘱𝘳𝘦𝘴𝘴𝘪𝘰𝘯 𝘸𝘪𝘵𝘩 3 𝘪𝘯𝘱𝘶𝘵 𝘱𝘢𝘳𝘢𝘮𝘦𝘵𝘦𝘳𝘴.
=MAP(A1:A10, B1:B10, SEQUENCE(10), LAMBDA(a, b, c, a+2*b-c))
//𝘶𝘴𝘦 𝘸𝘪𝘵𝘩 𝘯𝘢𝘵𝘪𝘷𝘦 𝘭𝘢𝘮𝘣𝘥𝘢  𝘰𝘳 𝘯𝘢𝘮𝘦𝘥 𝘭𝘢𝘮𝘣𝘥𝘢 𝘧𝘶𝘯𝘤𝘵𝘪𝘰𝘯
=MAP(A1:A10, ABS)
=MAP(A1:A10, LAMBDA(a, 2*a))
//𝘢𝘱𝘱𝘭𝘺 𝘭𝘢𝘮𝘣𝘥𝘢 𝘦𝘹𝘱𝘳𝘦𝘴𝘴𝘪𝘰𝘯 𝘸𝘪𝘵𝘩 3 𝘪𝘯𝘱𝘶𝘵 𝘱𝘢𝘳𝘢𝘮𝘦𝘵𝘦𝘳𝘴.
=MAP(A1:A10, B1:B10, SEQUENCE(10), LAMBDA(a, b, c, a+2*b-c))

RELATED