XLOOKUP in Excel | Step-by-Step Tutorial for Beginners (better than VLOOKUP) @chandoo_
XLOOKUP in Excel | Step-by-Step Tutorial for Beginners (better than VLOOKUP)  @chandoo_
Uploaded July 2025 | Updated November 2026, 1 day ago
Want to learn XLOOKUP? You have come to the right place.

"XLOOKUP is probably the most powerful XL function" - my grandma

How to use XLOOKUP?

=XLOOKUP(
value you want to find,
in the column where your data is,
specify the column you want as a result)

XLOOKUP Example 1:

=XLOOKUP(
"Richard",
B8:B42,
H8:H42)

XLOOKUP Example 2:

=XLOOKUP(
"EMP1012",
C8:C42,
B8:B42,
"Person not found")

Why use XLOOKUP?

XLOOKUP is an easy, versatile and powerful XL function that let's you search what you want in your data and get matching results. It is better version of VLOOKUP and INDEX+MATCH functions.

In this 6 minute video, learn how to use XLOOKUP in Microsoft Excel.

The video explains:
✅ How to use XLOOKUP?
✅What happens when XLOOKUP can't find the value?
✅XLOOKUP and returning the entire row
✅XLOOKUP with two sheets


More Excel XLOOKUP examples and explanation:

Read my detailed XLOOKUP article for full information - chandoo.org/wp/xlookup-examples

XLOOKUP Sample file - chandoo.org/wp/wp-content/uploads/2025/07/xlookup-howto.xlsx

XLOOKUP Advanced Techniques (10 powerful examples) - youtu.be/YyhJe5tMq58

I stopped using VLOOKUP, here is why - youtu.be/DDlZXXEI1bU

~

=XLOOKUP("best day ever", days, you)

#xlookup #excel
XLOOKUP in Excel | Step-by-Step Tutorial for Beginners (better than VLOOKUP)How I easily deal with 100s of columns in Excel ~ PRO Trick💡Email Excel Reports with Power Automate & Office Scrips - One Click Automation 🤖Combine Excel Sheets with *this* simple formulaExcel for Managers [FREE Masterclass]How to Remove Duplicate Values in Excel - Data Cleaning Tips🧹Easy XLOOKUP Hacks You Need To Try in Excel!Excel Magic Revealed: Unstacking Data Like a Pro! ✨Power BI Q&A - What is Microsoft Fabric? Tableau vs. Power BI, How important is SQL and more...Excel LOOKUP function is CRAZY 🤯 (fastest way to get tenure bands)Python for Data Analysis: The Beginner’s Ultimate Guide 🚀Create One Pivot Table from Many Sheets ~ AWESOME Excel Trick
Chandoo |

XLOOKUP in Excel | Step-by-Step Tutorial for Beginners (better than VLOOKUP)

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER