jkp-ads.com Excel Newsletter for January 2023
Happy new year to you and your loved ones!
The LAMBDA function
If you have a Microsoft 365 subscription you may have heard about the new LAMBDA function and wondered "What kind of strange function is that?".
In short: with this new LAMBDA function you can create your own worksheet functions, without writing a single line of (VBA) code.
A request I've heard a lot in the many years answering forum questions is this one: I need an Excel formula that will give me the name of the worksheet tab in any cell of that worksheet.
This is a simple enough request, with a relatively complicated answer:
Not something I'd like to type each time. I'd prefer writing: =SheetName(A1)
We can use the LET function to make the aforementioned formula slightly simpler:
Now we're just two steps away from transforming this into a Lambda.
1. Add the LAMBDA function to the previous formula (the only argument is a cell on the worksheet from which you want to display the name):
2. Define a name called SheetName and paste this formula into the Refers To box:
That's it, you can now get the sheet name into a cell with this simple formula:
Article about LAMBDA
I've written an article about the LAMBDA function here