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

By using advanced Excel functions, you can create a dynamic total row that seamlessly adapts to additions or deletions in your array.