LET Function

Premiumadvanced 15 min3 tasks0/36 pts

LET names the pieces of a calculation inside one formula. Define a name and its value, as many pairs as you like, then a final calculation that uses them. The formula reads like a sentence, and a repeated piece (like a lookup) is written once. Names only exist inside that formula.

Syntax

LET(name1, value1, [name2, value2], …, calculation)

Example: =LET(total,SUM(C2:C10),bonus,total*5%,total+bonus)

Common mistakes

Ending with a name/value pair instead of a calculation.
Using a name that looks like a cell (A1) or contains spaces.
Needs Excel 2021 or Microsoft 365.

XMATCH and INDEX/XMATCH LAMBDA Function

Topics/Dynamic Arrays and Advanced

LET Function

Premiumadvanced 15 min3 tasks0/36 pts

Syntax

LET(name1, value1, [name2, value2], …, calculation)

Example: =LET(total,SUM(C2:C10),bonus,total*5%,total+bonus)

Common mistakes

Ending with a name/value pair instead of a calculation.
Using a name that looks like a cell (A1) or contains spaces.
Needs Excel 2021 or Microsoft 365.

XMATCH and INDEX/XMATCH LAMBDA Function