XLOOKUP is a new feature in the latest version of Excel. It means you’ll no longer need to use either VLOOKUP or Index and Match, as it’s a much more powerful and accurate tool. It also allows you to use Wildcard characters such as * or ?, which means you can match parts of a string or account for misspellings.
In this two minute video, Gill explains how to use XLOOKUP with an example scenario.
Join 20,000+ professionals receiving workplace tips, leadership insights, and exclusive offers.
Since 1987, Happy has been igniting possibilities in people and organisations through great learning experiences. Be the first to hear about free resources, events, and training opportunities that make work more joyful and productive.
3rd Floor
Robert Dolan House, 9 Alie Street
London E1 8DE
United Kingdom
Save the date for the next conference Wednesday, 12th November 2025
Build your Excel skills from beginner to expert. Perfect for mastering data analysis and visualisation.
Outline the 10 core principles for a happy workplace. It has since helped thousands of leaders build trust-driven, empowered teams.
Sign up for our Happy Manifesto newsletter and discover fresh ways to ignite joy and productivity at work. Get expert tips, insights, and ideas that challenge the norm—straight to your inbox. Join our movement and start your journey for a trust-based, values-led organisation.
Sign up for our Happy Manifesto newsletter and discover fresh ways to ignite joy and productivity at work. Get expert tips, insights, and ideas that challenge the norm—straight to your inbox. Join our movement and start your journey for a trust-based, values-led organisation.
