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:

Welcome X Functions – XLOOKUP

If you’d like to learn more, I teach a free 20 minute webinar on XLOOKUP:

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.

Excel is not what it used to be.

You need the Excel Proficiency Roadmap now. Includes 6 steps for a successful journey, 3 things to avoid, and weekly Excel tips.

Want to learn Excel?

Access all Undergrad and Masters lessons with a Campus Pass or CPE Pass. Includes on-demand training plus live office hours.

Leave a Comment