VLOOKUP vs XLOOKUP - Detailed Comparison with Examples

XLOOKUP is a new and improved version of the VLOOKUP and HLOOKUP functions. It addresses many of the shortcomings of the VLOOKUP function.
In this video, I will give you a detailed view of the differences between the XLOOKUP and the VLOOKUP function. The video covers multiple examples that will make it easy for you to understand the difference between these two functions with practical use cases.
✅ Download Example File - www.dropbox.com/scl/fi/8245sb...
00:00 Intro
00:28 XLOOKUP vs VLOOKUP Syntax Difference
02:19 Hard-coded Column No (VLOOKUP) vs Return Array (XLOOKUP)
04:59 XLOOKUP can look on the left of Lookup Column
06:35 XLOOKUP Uses Exact Match by Default
08:17 XLOOKUP can look-up in the bottom to top direction
10:28 XLOOKUP can return multiple values
12:38 XLOOKUP can return specific value in case of no match
14:22 XLOOKUP approximate match doesn't need a sorted dataset
17:40 XLOOKUP has a wildcard match mode
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: kzbin.info...
#Excel #ExcelTips #ExcelTutorial #SumitBansal

[@sekharispassion]

Sir, thanks a lot for the detailed video. Till now I have used vlookup and index match for analysing data. Now will practice xlookup as explained in the video and improve my skills in excel.

[@trumpexcel]

XLOOKUP is way better if you have access to it. So good idea to switch to it from VLOOKUP and INDEX MATCH

[@IvanCortinas_ES]

Complete tutorial. It is imperative to know all these possibilities. Thank you Sumit!

[@trumpexcel]

Thanks Iván 🙂

[@Sidharth.Pratap]

This is superb.. thanks a ton :)

[@PrincesDiana8966]

Thank you so much!........... you 've covered huge information in just 20 minutes vedio.

[@jasonstube7074]

Thanks for You's video!👍👍👍

[@jhankhanajani9314]

Thank you Sumit for amazing comparison !!

[@mboush123]

Many thanks

[@amytoi5449]

Definitely using xlookup now!

[@danm.9109]

Thank you for the video!

[@gautamudas]

Ahh throughout my career I was searching for this function 😮

[@juleekumari2810]

Helpful!

[@kousikdey62]

Today's dashboard and visualization is becoming very important please also add these in your tutorials. BI's

[@MrFaisalgk01]

New subscriber came after watching reels

[@trumpexcel]

Welcome... and thank you for subscribing 🙂

[@Sonu-khorwal]

Yesss 😅

[@gaganwadhwafreelancer]

Plz share Practice sheet

[@trumpexcel]

Here is the download link for the example file used in the video - www.dropbox.com/scl/fi/8245sbbp534rxkyv715vh/XLOOKUP-vs-VLOOKUP.xlsx?rlkey=7km32mag87r6gbbk0f70614sy&dl=1

[@devidaskulkarni6997]

Hi