The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

In Excel spreadsheets, complex formulas are difficult to enter without making mistakes. Microsoft Excel’s LAMBDA() function can make such errors easier to find.

As I mention in How to use Excel’s Data Model to turn related data into meaningful information, you might create complete records on a single sheet using complex formulas to lookup data.