# MAP

Processes each row in an array with a formula including a COL or CELL keyword and returns it as a 2D array.

## Syntax

```
MAP(array, lambda)
```

## Arguments

| Argument | Description                        | Required |
| -------- | ---------------------------------- | -------- |
| `array`  | The array to process              | Required |
| `lambda` | The lambda function to apply to each row | Required |

## Examples

### Double each value in array

=MAP(A1:A4, COL[1]*2)

Result ⇒Array: [[2], [4], [6], [8]]

|     |     |
| --- | --- |
|     | A |
| 1   | 1 |
| 2   | 2 |
| 3   | 3 |
| 4   | 4 |

### Calculate square of each number

=MAP(A1:A3, CELL^2)

Result ⇒Array: [[25], [100], [225]]

|     |     |
| --- | --- |
|     | A |
| 1   | 5 |
| 2   | 10 |
| 3   | 15 |

### Convert temperatures from Celsius to Fahrenheit

=MAP(A1:A3, COL[1]*9/5+32)

Result ⇒Array: [[32], [68], [212]]

|     |     |
| --- | --- |
|     | A |
| 1   | 0 |
| 2   | 20 |
| 3   | 100 |

## Related Functions

Other Data functions:

- [CHOOSE](/content/docs/formulas/choose.html) - Uses index to return a value from the list of value arguments
- [COLUMN](/content/docs/formulas/column.html) - Returns the column number of the current cell context.
- [DROP](/content/docs/formulas/drop.html) - Drops the first N rows and optionally first N columns from an array. Returns an error if the result would be empty.
- [FILTER](/content/docs/formulas/filter.html) - Returns a filtered array containing only rows that match the criteria
- [GROUPBY](/content/docs/formulas/groupby.html) - Groups data by a key and applies an aggregator function to each group
- [HLOOKUP](/content/docs/formulas/hlookup.html) - Returns the corresponding value from the specified row of table which matches exactly or approximately to the first row of the table.
- [HSTACK](/content/docs/formulas/hstack.html) - Horizontally stacks arrays by appending columns
- [INDEX](/content/docs/formulas/index.html) - Returns a cell value from a list or table based on its column and row numbers.
- [LAST](/content/docs/formulas/last.html) - Returns the last N rows and optionally last N columns from an array. Returns an error if the result would be empty.
- [MATCH](/content/docs/formulas/match.html) - Returns the position of the item/lookup_value in the lookup_array or range.
- [PICK](/content/docs/formulas/pick.html) - Selects specific columns from an array using column numbers or header names
- [ROW](/content/docs/formulas/row.html) - Returns the 1-indexed row number of the current cell
- [SEQUENCE](/content/docs/formulas/sequence.html) - Returns the list of generated sequential numbers in an array.
- [SORT](/content/docs/formulas/sort.html) - Sorts the values in a range or array.
- [SORTBY](/content/docs/formulas/sortby.html) - Sorts a range or array based on values in one or more corresponding ranges or arrays.
- [TAKE](/content/docs/formulas/take.html) - Returns the first N rows and optionally first N columns from an array. Returns an error if the result would be empty.
- [TRANSPOSE](/content/docs/formulas/transpose.html) - Returns the result after transposing the rows and columns of an array or range.
- [UNIQUE](/content/docs/formulas/unique.html) - Returns a list of unique values in a list or range.
- [VLOOKUP](/content/docs/formulas/vlookup.html) - Returns a value from a table by looking up a value in the first column and returning a value from the specified column
- [VSTACK](/content/docs/formulas/vstack.html) - Vertically stacks arrays by appending rows
- [XLOOKUP](/content/docs/formulas/xlookup.html) - Searches a range or array for a match and returns the corresponding item from a second range or array. Supports exact and approximate matching, wildcards, and reverse search.