Google Sheets | MAP | Function | LAMBDA | How to Use | Example | Spreadsheet | Tutorial | Formula
With the Google Sheets MAP function, you can map an array element to another value, using a LAMBDA function. It applies to each element of the array. Let's consider an example. Say there are three tables that have the sales data of each quarter for three financial years. MAP can be used, for example, to get the maximum sales revenue in each quarter in each of the years.
-------------------------------------
How to Use REDUCE in Google Sheets?
Use REDUCE to get the final value of intermediate calculations:
• Google Sheets | REDUCE | Function | R...
-------------------------------------
How to Use SCAN in Google Sheets?
It's easy to calculate running total, running count and the like with SCAN:
• Google Sheets | SCAN | Function | Cal...
-------------------------------------
How to Use QUERY in Google Sheets?
QUERY helps, among others, to extract specific or all data from a range:
• Google Sheets | QUERY | Function | Ex...
-------------------------------------
How to Use Convert to Table in Google Sheets?
Convert a data range into a table easily:
• Google Sheets | Convert to Table | Ch...
-------------------------------------
How to Use FREQUENCY in Google Sheets?
FREQUENCY returns the frequency distribution of data:
• Google Sheets | FREQUENCY | Function ...
-------------------------------------
How to Use COUNTIFS in Google Sheets?
Count values that fulfill one or more criteria:
• How to use COUNTIFS in Google Sheets ...
-------------------------------------
How to Use XLOOKUP to Extract Multiple Values in Google Sheets?
XLOOKUP can return a single row or column with the search key:
• Google Sheets | XLOOKUP | Function | ...
-------------------------------------
How to Use VLOOKUP in Google Sheets?
Use VLOOKUP to get a single value:
• VLOOKUP Google Sheets | How to Use VL...
-------------------------------------
How to Create a Pivot Table in Google Sheets?
Create a pivot table for calculation and in-depth data analysis:
• Google Sheets | Pivot Table | How to ...
-------------------------------------
Syntax of the MAP Function Formula
=MAP(array1, [array2, …], lambda)
array1 is the first array whose elements are to be mapped to another value.
array2 and other arrays are optional.
lambda is a custom function. It is applied to each element of the array.
The lambda should have as many name arguments, as the number of arrays passed to it. Lambda should also have a formula expression, which uses the name arguments.
Example of MAP Function
Here is an example:
A MAP function that maps each element of an array to the element's cube root.
Assume that cells A2 to A4 have 25, 45, and 65 respectively.
The MAP function formula is:
=MAP(A2:A4,lambda(input,input^3))
Lambda receives each element of the array A2:A4 has its input. Then, lambda returns the cube root of each number.
The output of MAP function is 15625, 91125, and 274625.
Take a look at this video tutorial, which gives the steps to use the Google Sheets MAP function, with examples.