Create an account to use AI

Create a free account to unlock all features:

Ask questions about videos with AI
Use smart search (AI)
Save your favorite videos
Bookmark your favorite categories
Organize your favorite subcategories
Access your personalized favorites page
Access your conversation history
Personalize your homepage with your favorites

Create an account

Already have an account? Log in

Xlookup In Excel: Explained In 3 Minutes

Excel Campus - Jon

Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

In this video, I give a brief overview of the new XLOOKUP function in Excel, an alternative to VLOOKUP or INDEX MATCH.

Here are some of the major features of XLOOKUP that I share in the video:

1. Only 3 Required Arguments

2. Exact Match by Default

3. Separate Lookup & Return Ranges

4. Vertical OR Horizontal Lookup

5. Partial Match with Wildcards

6. Reverse Search Order

7. Cause of # VALUE! Error

8. Availability & Compatibility

The XLOOKUP function searches for the lookup value in a column/row and returns a value from an adjacent row/column where the match is found.

It has options for exact match, closest match, and partial match with wildcard characters. It can also search in reverse order.

Additional Resources:

Full In-Depth Tutorial on XLOOKUP: https://youtu.be/pURSha68Mjs

Blog post on XLOOKUP: https://www.excelcampus.com/functions/xlookup-explained/

VLOOKUP Tutorial: https://youtu.be/d3BYVQ6xIE4

VLOOKUP Assistant Preview: https://youtu.be/g2_Yu_VRQ9E

Please leave a comment below with any questions or suggestions. Thank you! 🙂

#ExcelCampus #MsExcel

00:00 Introduction

00:50 XLOOKUP

01:58 Search Order

Xlookup In Excel: Explained In 3 Minutes | Knoovi