New and improved, XLOOKUP for Excel
News|7 October 2019
Microsoft has announced that the iconic VLOOKUP function for Excel will be replaced by XLOOKUP.
For 34 years VLOOKUP has been a staple function in Excel with many users using the mastering of it a milestone in their spreadsheeting abilities.
What is XLOOKUP?
XLOOKUP is able to look both vertically and horizontally and in its simplest form only needs three arguments to perform an exact lookup – that’s on fewer than VLOOKUP (and HLOOKUP). So the formula looks something like this:
XLOOKUP (lookup_value, lookup_array, return_array)
Advanced XLOOKUP variations
XLOOKUP also has fourth and fifth mode arguments that allow you to perform advanced lookups: match_mode and search_mode.
Why is XLOOKUP better?
1) It defaults to an exact match, which was not VLOOKUP’s default behaviour.
2) It supports column insertions and deletions, which VLOOKUP’s third argument disallowed.
3) Circumvents the need to rearrange data, with XLOOKUP you can return values from a column to the left.
4) You no longer need to reverse the order of your data to find the last occurrence.
5) Can search for the next larger item and the next smaller item.
6) Using lookup_array rather than table_array means you no longer have to reference more cells then you really need for your calculation, increasing the performance of your spreadsheets.
For more information on XLOOKUP and its full capabilities, read this useful article by ExcelJet.
Contact Grey Matter
If you have any questions or want some extra information, complete the form below and one of the team will be in touch ASAP. If you have a specific use case, please let us know and we'll help you find the right solution faster.
By submitting this form you are agreeing to our Privacy Policy and Website Terms of Use.
Related News
We’re now a Kiteworks reseller partner
We’re excited to announce that we’re now a Kiteworks reseller partner to help you improve your file sync and sharing experiences, as well as improve security best practices. “Having Kiteworks as a partner enables us to deliver secure, enterprise-grade Managed File Transfer, File Share and Collaboration, and...
Microsoft Agent 365 – AI agents tailored to your business
We’ve just launched our new four-part video series exploring Agent 365 and the rise of AI agents inside Microsoft Copilot. You’ll learn what AI agents are, why they matter, and how to start using them within the Microsoft ecosystem. Each episode focuses on real-world use cases,...
AI in software development: from simple coding to agentic engineering
Software development is undergoing a major change in the way developers work with and create code. AI in software development has moved beyond the novelty of “look what it can generate” and into something even more useful: agentic engineering. That shift doesn’t remove developers...
Microsoft 365 is getting a price update – here’s what’s changing
Microsoft has announced a global pricing update, coming into effect for new purchases and renewals from 1 July 2026. For many businesses, this means higher licence costs – but it also creates opportunities to review, optimise, and in some cases, reduce overall spend. Microsoft 365...