HDTutorial
EN
How to Use the NEW & IMPROVED Excel XLOOKUP (with 5 Examples)

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Use the NEW & IMPROVED Excel XLOOKUP (with 5 Examples)

3,967,617 views November 29, 2019 13:34

Watch on YouTube
ChannelLeila Gharani

In brief

Master Excel’s XLOOKUP function to handle missing data, partial matches, and complex lookups—ideal for users upgrading from VLOOKUP or INDEX MATCH. This tutorial covers five practical examples, from horizontal searches to approximate matches, all demonstrated in real-time with Office 365 or 2021.

Key steps

  1. Compare XLOOKUP to VLOOKUP and INDEX MATCH for efficiency gains
  2. Set up error handling for missing or unmatched lookup values
  3. Search horizontally across columns using XLOOKUP instead of HLOOKUP
  4. Use wildcards (like asterisks) for partial text matches in data
  5. Perform two-way lookups across rows and columns simultaneously

Questions & answers

Which Excel versions support XLOOKUP?

Office 365 and Excel 2021.

Can I use wildcards with XLOOKUP?

Yes, the video shows how to use wildcards for partial matches.

Chapters

Description from the creator

🔥 Want results you can see? Join 500,000+ professionals upgrading their skills today 👉 link.xelplus.com/yt-d-all-courses

Discover the powerful capabilities of Excel's XLOOKUP function in this detailed tutorial. Ideal for Excel users looking to enhance their data lookup skills. XLOOKUP offers a more versatile and efficient approach compared to traditional functions like VLOOKUP and INDEX MATCH.

⬇️ Download the file I used in the video from here: xelplus.com/excel-xlookup-advanced/?utm_source=…

If you'd like to learn about the other brand new Excel functions like FILTER & UNIQUE check out the complete course 👉 xelplus.com/course/excel-dynamic-array-365-form…

In This Tutorial, You'll Learn:
▪️ Handling Missing Items: Understand how to effectively manage errors and missing items in data using XLOOKUP.
▪️ Using Wildcards for Partial Matches: Explore partial match lookups in XLOOKUP with wildcard characters.
▪️ Simplifying Horizontal Lookups: Replace HLOOKUP with the more efficient XLOOKUP for horizontal data searches.
▪️ Mastering Two-Way Lookups: Learn to conduct searches across both rows and columns using XLOOKUP.
▪️ Performing Approximate Matches: Gain insights on how to execute approximate matches for nuanced data analysis with XLOOKUP.

00:00 What is Excel's New XLOOKUP Function
01:15 Lookup Value Not Found with XLOOKUP
04:06 Horizontal Lookup with XLOOKUP in Excel
05:44 Look For Partial Match with XLOOKUP
07:51 Two-Way Lookup with XLOOKUP
10:29 Approximate Match with XLOOKUP

*** AVAILABILITY *** The XLOOKUP function is available to Office 365 and 2021 users.

LINKS to related videos
First XLOOKUP video: youtu.be/xnLvEhXWSas
Excel left lookup with XLOOKUP: youtu.be/Xz1KHEhqUCY

➡️ Join this channel to get access to perks: youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/jo…

🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz/

🎥 RESOURCES I recommend: xelplus.com/resources/

🚩Let’s connect on social:
Instagram: instagram.com/lgharani
LinkedIn: linkedin.com/company/xelplus

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#excel

About this tutorial

Leila Gharani published this 13:34 video tutorial on November 29, 2019. It has been watched 3,967,617 times on YouTube.

Category
Education
Duration
13:34
Published
November 29, 2019
Views
3,967,617
Likes
73,256

Tags

Share

This tutorial in other languages