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 realized how useful XLOOKUP is, I knew I’d never look back. I’ll use direct cell references to exemplify my points in this article, as they are clearer […]