Get the Calling Cell Address in an Excel LAMBDA Function
Question details
The user wants an Excel LAMBDA function to identify the cell that calls it reliably.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A named LAMBDA function needs to use the address of the cell containing its formula.
- Observed behavior
- CELL, ROW, COLUMN, or volatile references used without an explicit calling-cell argument can produce context-dependent or inconsistent results.
Use a version of Excel that supports LAMBDA and check that the workbook allows you to create named formulas in Name Manager.
Pass the calling cell address as a LAMBDA argument
Use an explicit argument when a named LAMBDA needs the address of the cell containing its formula.
In Excel, select Formulas > Name Manager > New. Enter MyLambda as the name and set Refers to to =LAMBDA(adr,"LAMBDA invoked from "&adr).
In the worksheet cell you want to identify, enter =MyLambda(ADDRESS(ROW(),COLUMN())).
Press Enter. For example, a formula entered in B2 returns LAMBDA invoked from $B$2.

Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Office format compatibility for a smooth move between applications. Check advanced formula compatibility before relying on an Excel LAMBDA workbook in WPS.

Frequently Asked Questions
Why should I pass the address into the LAMBDA?
An explicit argument makes the required calling-cell address part of the function call instead of relying on context-sensitive behavior. Enter =MyLambda(ADDRESS(ROW(),COLUMN())) in the calling cell.
Can I pass a cell reference instead of its address?
Yes. Define a LAMBDA parameter for the cell reference and supply the reference in the function call, such as =MyLambda(B2). Use an address argument when the function specifically needs address text.
Why does the example return $B$2 rather than B2?
ADDRESS returns an absolute reference by default. To return a relative address instead, use ADDRESS(ROW(),COLUMN(),4) in the LAMBDA call.
Where do I edit an existing named LAMBDA?
In Excel, open Formulas > Name Manager, select the named function, and choose Edit to change its Refers to formula.




