Formulas > =MAP()
How To Use MAP() Function in Google Sheets
Description
How To Actually Use MAP() in Sheets
MAP(array1, [array2, ...], LAMBDA)
Try MAP yourself
In the range A1:A5, enter some numbers. Use the MAP function to double each value and display the results in the range B1:B5.
Hints (2)
-
Remember to use the LAMBDA function to define how to transform each value.
-
Think about how to reference the values in the array you want to map.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the MAP() formula:
Generate a MAP() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses MAP(). 2 free AI generations, no signup. Members get unlimited use.
Generate a MAP() formula