Excel’s New XLOOKUP Function Now Generally Available

Posted on February 10, 2020 by Mehedi Hassan in Microsoft with 10 Comments

Back in August of last year, Microsoft introduced a major new function for Microsoft Excel. The company introduced the world to XLOOKUP, a new Excel function that is succeeding Excel’s iconic VLOOKUP function.

At the time, Microsoft said VLOOKUP was one of the most popular Excel functions used worldwide, existing in the app for 35 years. Microsoft is now introducing the new XLOOKUP function that will succeed VLOOKUP, which was first in testing with Insiders, and is now generally available.

XLOOKUP allows users to look for values both vertically and horizontally, removing the need for the HLOOKUP function as well. “XLOOKUP helps users find what they need more efficiently with fewer limitations, from being able to look up a value vertically and horizontally (and to the left!) to supporting column insertions and deletions and more,” said Microsoft.

XLOOKUP does look like a very handy function much like its predecessors VLOOKUP and HLOOKUP. If you use Excel at all, you will probably want to check out the full features and commands available for the function here. 

Tagged with ,

Elevate the Conversation!

Join Thurrott Premium to enjoy our Premium comments.

Premium member comments on news posts will feature an elevated status that increases their visibility. This tab would allow you to participate in Premium comments with other premium members. Register to join the other Premium members in elevating the conversation!

Register or Subscribe

Join the discussion!


Don't have a login but want to join the conversation? Become a Thurrott Premium or Basic User to participate