XLOOKUP Made Easy: Simplifying Complex Data Searches in Excel

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.

The Happy Manifesto

Outline the 10 core principles for a happy workplace. It has since helped thousands of leaders build trust-driven, empowered teams.

Thanks for your enquiry.

We've received your message and will get back to you soon. In the meantime, you may find this of interest:

The Happy Manifesto

The Happy Manifesto features ten core principles for creating happier, more engaging places to work. We offer all of Henry's books as free downloads.

Want more ideas for creating happy, productive workplaces?

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.

Want more ideas for creating happy, productive workplaces?

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.