MicrosoftComing from an OOP background, I almost immediately thought of putting LAMBDA together with Data Type to get a form of encapsulation.
eg: You have a table containing Employees (maybe coming) from a database (or inside your own sheet), with FirstName, LastName, DateOfBirth, DateJoinedFirm etc, and maybe a transformed field DisplayName. Put all those columns into a Data Type with the type called Employee. These are the properties of your "object".
Then you can start creating LAMBDAs that understand Employees. Eg a Name'd LAMBDA, Employee.Pension (the '.' is accepted as a Name though unsure if it's a good idea)
=LAMBDA(empl,1000 * (int((TODAY()-empl.DateJoinedFirm)/365)))
With your employee data in cell B1, say, you can now call =Employee.Pension(B1)
Or is this too contrived?
