When entering the functions, if you use the selection method to insert references, you will see Excel’s Table structure referencing at work instead of the actual range (array) references that I use.

Microsoft Excel's dynamic array function XLOOKUP() might completely replace VLOOKUP() and HLOOKUP().

Dynamic arrays allow you to perform calculations across multiple cells without manually adjusting formulas for each row. This capability is crucial for running totals, where each row’s total ...

This guide by Excel Off The Grid will walk you through a step-by-step method to dynamically insert blank rows between items, whether you’re sorting, filtering, or grouping data.