How to Use MAP Function in Excel + Tips

Hello everyone! Today I show you how to use MAP function in Microsoft Excel 365 and Excel 2024+ step by step with simple example.

You ever have a list of number and you want apply same formula to every single item in that list? Normal way you drag formula down one by one. But MAP function can do it all at once — one formula, apply to every item, return result as new array. Very powerful and very fast!

1. What is MAP Function in Excel?

MAP function let you apply a custom formula to each item in your array or range, and it return all the result at once as new array.

Think of MAP like a machine. You put all your item inside the machine, the machine do same thing to every item, then give you back all the result. You no need loop, no need drag formula down — MAP do everything automatic!

Why MAP is useful:

1. Apply formula to whole column at once — No need drag down formula one by one
2. Work with LAMBDA together — You define what calculation to do, MAP apply it to everything
3. Return dynamic result — If your data change, result update automatic

📚 Related Tutorial: MAP use LAMBDA inside it, so you should understand LAMBDA first! Check out How to Use LAMBDA Function in Excel!

2. Formula Syntax & Parameters

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

• array1 — Required. Your first range or array that you want apply formula to. Example: A2:A10
• [array2, ...] — Optional. More array if your formula need more than one input. Example: B2:B10
• lambda — Required. The LAMBDA function that tell MAP what calculation to do on each item

Important: The lambda part inside MAP must use LAMBDA() function. You cannot just put normal formula there.

3. Practical Examples

Example 1: Double Every Number in a List

You have number in A2:A6 and you want make new list where every number is multiply by 2:

=MAP(A2:A6, LAMBDA(x, x * 2))

👉 Result: If A2:A6 have 1, 2, 3, 4, 5 — MAP return 2, 4, 6, 8, 10. All number double at once!

The LAMBDA(x, x * 2) mean: for each item, call it x, then calculate x * 2.

Example 2: Calculate Price After Tax for Each Item

You have product price in A2:A10 and tax rate is 10%. You want calculate final price with tax for each product:

=MAP(A2:A10, LAMBDA(price, price * 1.1))

👉 Result: Every price in A2:A10 get multiply by 1.1 (add 10% tax). All calculation done in one formula!

Example 3: Use Two Array — Calculate Total Price

You have quantity in A2:A6 and unit price in B2:B6. You want calculate total for each row:

=MAP(A2:A6, B2:B6, LAMBDA(qty, price, qty * price))

👉 Result: MAP take quantity and price for each row, multiply them together, return total for every row at once!

💡 Tip: When you use two array in MAP, make sure both array have same size (same number of row and column). If size not match, MAP will give you error.

Example 4: Classify Each Number as "High" or "Low"

You have score in A2:A8. You want label each score — if more than 70 show "High", if not show "Low":

=MAP(A2:A8, LAMBDA(score, IF(score > 70, "High", "Low")))

👉 Result: Every score get check automatic. Above 70 show "High", below 70 show "Low". All in one formula!

💡 Tip: You can put any formula inside LAMBDA — IF, LEN, UPPER, ROUND, anything you want. MAP will apply it to every item in your array.

4. MAP vs Normal Formula — What is Difference?

💡 Quick Tips for Using MAP Function

1. Learn LAMBDA first: MAP cannot work without LAMBDA. Make sure you understand how LAMBDA work before you use MAP.
2. Same size array: If you use two or more array in MAP, all array must have same number of row and column, otherwise you get error.
3. Use meaningful parameter name: Inside your LAMBDA, give clear name like price, qty, score instead of just x. Easier to read later.
4. Combine with other function: MAP work great with IF, ROUND, TEXT, LEN, and many more formula inside the LAMBDA part.
5. Excel Version Requirement: MAP function require Microsoft 365 or Excel 2024 or newer. Not available in old Excel version.

📚 Related Resources & Tutorials

• How to Use LAMBDA Function in Excel
• How to Use LET Function in Excel
• How to Use DROP Function in Excel
• TAKE vs FILTER Function in Excel Explained
• VSTACK vs HSTACK Function in Excel Explained
• Free Download PDF - 50 Popular Excel Formulas Cheatsheet (Khmer Language)