The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

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

How Double X Lookup Works The Double X Lookup function is built on the foundation of Excel’s INDEX and XMATCH functions, which together enable precise vertical and horizontal lookups.