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.

As a long-term Excel enthusiast, I have always enjoyed using VLOOKUP, one of Excel's best-known lookup functions. However, Microsoft's introduction of XLOOKUP in 2019 changed everything. Once I ...