Function Problems

Get the Calling Cell Address in an Excel LAMBDA Function

Rana GarciaRana Garcia Nov 18, 2026 869 views

Question details

The user wants an Excel LAMBDA function to identify the cell that calls it reliably.

Get the Calling Cell Address in an Excel LAMBDA Function
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.
Before you start

Use a version of Excel that supports LAMBDA and check that the workbook allows you to create named formulas in Name Manager.

Solution 1Recommended

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.

1
Create the named function

In Excel, select Formulas > Name Manager > New. Enter MyLambda as the name and set Refers to to =LAMBDA(adr,"LAMBDA invoked from "&adr).

2
Call the function from a cell

In the worksheet cell you want to identify, enter =MyLambda(ADDRESS(ROW(),COLUMN())).

3
Check the result

Press Enter. For example, a formula entered in B2 returns LAMBDA invoked from $B$2.

Pass the calling cell address as a LAMBDA argument
Avoid active-cell assumptions: Pass the address or required cell reference explicitly rather than relying on the active cell or cursor position. For a spilled formula, the formula is entered in the spill's anchor cell, so the address identifies that cell.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLSX and XLS files.Use a familiar spreadsheet interface to review formulas and cell addresses.Work with documents, spreadsheets, and presentations in one lightweight suite.Get started with a free Office alternative.
microsoft office alternative - wps office

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.