VLOOKUP is perhaps the most iconic function in Excel and users have come to adore it.

As great as VLOOKUP is, it has several limitations. For example, column order matters. It was designed to look for a matching value in the first (left-most) column within the lookup range. Once found, it scans to the right (not left) to retrieve the related value. Also, it is one of the few functions that can break when we insert a new worksheet column. Despite these limitations, Excel users love VLOOKUP.

But friends, it is time to, like Frozen’s Elsa, “let it go.” You see, Microsoft has addressed these limitations in the next gen lookup function, XLOOKUP.

Check out my recent CalCPA Article if you’d like to learn more:





Posted in , ,

Jeff Lenning

I love sharing the things I've learned about Excel, and I built Excel University to help me do that. My motto is: Learn Excel. Work Faster.

Stay Connected

If you'd like to be notified when I write a new Excel article, enter your name and email and click SUBSCRIBE. You can unsubscribe anytime, and I will never sell your email address.

Want to learn Excel?

Our Campus Pass includes access to our entire Undergrad and Masters catalog. Gamification ensures it is the most fun you can have learning Excel :)

Leave a Comment