ExcelFlux

MAP function

an array formed by mapping each value in the array(s) to a new value by applying a LAMBDA to create a new value.

Logical · Excel 2024+ · Guided Excel example

Where can you use it?

Teams building reports and business rules. Adapt the example’s decision rule when you need to test a condition or display different results based on it.

Scenario in the workbook

Apply the same transformation to three inputs. This lambda doubles each value.

A worked example from the workbook

RowABC
6ValuePositionReading
7114
8429
97314
Record 1
=INDEX(MAP($A$7:$A$9,LAMBDA(value,value*2)),B7)

Illustrative output2

See the inputs and instructions for all 3 examples

Worked examples

Apply the same transformation to three inputs. This lambda doubles each value.

Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.

Row A B C
6 Value Position Reading
7 1 1 4
8 4 2 9
9 7 3 14
Trial Expression Sample output
Record 1 =INDEX(MAP($A$7:$A$9,LAMBDA(value,value*2)),B7) 2
Record 2 =INDEX(MAP($A$7:$A$9,LAMBDA(value,value*2)),B8) 8
Record 3 =INDEX(MAP($A$7:$A$9,LAMBDA(value,value*2)),B9) 14
Microsoft Excel reference