Before LAMBDA was introduced to Excel, you'd need to know how to use VBA or macros to create your own function ... I'll show you how it works in a basic example. Open a blank Excel workbook ...

Excel's OFFSET function lets you create a reference that isquite literallyoffset from a starting point. It allows references to adjust dynamically to changes in your spreadsheet's data and structure.