Skip to main content Copilot Word Excel PowerPoint Outlook OneDrive Teams Copilot Studio Work IQ Cowork Individuals Business Enterprise Education Plans and pricing Support Customer stories Blog Copilot vs. competitors Tech community Frontier program AI for Work Roadmap Agents New user onboarding Roll-out and adoption Prompts and use cases AI knowledge Connectors Open Copilot Download the app

Discover what’s coming to Microsoft Ignite, Nov 17-20, 2026. Register now.

Image of two workers collaborating at a PC.

The highly anticipated XLOOKUP function in Excel is generally available for all users across Windows, Mac, and Excel on the web. XLOOKUP is the successor to the iconic VLOOKUP function, which has been one of the most used functions in Excel.

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.

An animated image of Excel's XLOOKUP function being used on a tablet. The user is looking up offices, names, and roles.

Previously, we released XLOOKUP to Office Insiders and received lots of excitement and feedback on the feature. While you can still perform VLOOKUP functions, we encourage you to try XLOOKUP for better and faster results. For more information on XLOOKUP, read our help article and our previous announcement of XLOOKUP’s Office Insiders release.

Stay updated

To stay updated on the latest Excel news, follow the Excel blog on Tech Community and Excel on Facebook and Twitter. Also, to try XLOOKUP and other new features in Excel, make sure you have the latest version of Excel.

Microsoft

The Microsoft 365 Marketing Team


See more articles from this author

, ,
,