Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
MAP
MAP iterates over one or more arrays and applies a LAMBDA function to corresponding elements, returning a new array of the same dimensions. It replaces the need for helper columns or array-entered formulas when you want to transform every value in a range using custom logic.
Excel
=MAP(A2:A5,LAMBDA(x,x*2))Google Sheets
=MAP(A2:A5,LAMBDA(x,x*2))Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Prepare the range to transform (e.g., A2:A5 with numeric values) and decide on the transformation logic.
- 2Enter =MAP(A2:A5,LAMBDA(x,x*2)) to multiply every value in the range by 2, spilling results into adjacent cells.
- 3Pass multiple ranges to MAP for element-wise operations: =MAP(A2:A5,B2:B5,LAMBDA(a,b,a+b)) adds corresponding elements.
Need a version for your data?
Try: “Double every number in a column using a custom transformation formula”