How to Use XLookup in 2 Minutes

In this quick Excel tutorial, you’ll learn how to use the XLOOKUP function in Microsoft Excel to find values in a table or range—fast and without confusion.

We’ll start with a simple XLOOKUP example using a unique identifier, like:
Looking up a product price by part number
Finding an employee name using an employee ID

Then, we’ll level up and cover XLOOKUP with multiple columns, which is useful when:
One column alone isn’t unique
You need to combine values (like first name + last name) to get an accurate match
In the final example, I walk through a real-world sales dataset and show how to return the sales value for a specific segment.

👉 If your data doesn’t have unique rows, check out my tutorial on the Excel FILTER function for an alternative approach.

This video is perfect for Excel beginners, students, professionals, and anyone who wants to learn modern Excel functions quickly.

⏱️ What you’ll learn:
How XLOOKUP works in Excel
XLOOKUP with a unique lookup column
XLOOKUP using multiple columns
Common beginner mistakes to avoid

🔔 More quick Excel & tech tutorials:
Subscribe to Learning With Dr. E for practical skills—explained clearly and in minutes.

#Excel
#XLOOKUP
#ExcelTutorial
#ExcelForBeginners
#MicrosoftExcel
#ExcelTips
#LearnExcel
#ExcelFunctions
#OfficeSkills
#DataSkills
#Productivity
#LearningWithDrE