Cleaner Formulas With Named LAMBDAs
Save a LAMBDA in the Name Manager for use across the workbook.
From Inline to Named
So far you have called LAMBDAs inline, typing the whole definition each time. That works for testing but is messy for everyday use.
A named LAMBDA stores your function under a friendly name so you can call it like =ToFahrenheit(A2) anywhere in the workbook. This is where LAMBDA truly shines, turning your formulas into a reusable toolkit.
In this lesson you will save LAMBDAs in Excel's Name Manager and Google Sheets' Named functions, then call them across your sheets.
The Name Manager in Excel
Excel stores named items, including named LAMBDAs, in the Name Manager.
Open it from Formulas, Name Manager, then click New. You will give your function a Name and paste the LAMBDA into the Refers to box.
The key rule: paste the LAMBDA without any inline values at the end. The arguments will be supplied later when you call the name.
All lessons in this course
- Naming Steps With LET
- Defining Custom Functions With LAMBDA
- Looping With MAP and REDUCE
- Cleaner Formulas With Named LAMBDAs