VLOOKUP vs XLOOKUP - Detailed Comparison with Examples

Рет қаралды 5,994

Күн бұрын

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: kzfaq.info...
#Excel #ExcelTips #ExcelTutorial #SumitBansal

Пікірлер: 21

@IvanCortinas_ES Ай бұрын

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

@trumpexcel Ай бұрын

Thanks Iván 🙂

@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

@PrincesDiana8966 Ай бұрын

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

@danm.9109 Ай бұрын

Thank you for the video!

@jhankhanajani9314 Ай бұрын

Thank you Sumit for amazing comparison !!

@Sidharth.Pratap 27 күн бұрын

This is superb.. thanks a ton :)

@amytoi5449 Ай бұрын

Definitely using xlookup now!

@oluwaseunoluwafunmilola8848 17 күн бұрын

I am so excited with you. Thanks 👍

@jasonstube7074 Ай бұрын

Thanks for You's video!👍👍👍

@juleekumari2810 Ай бұрын

Helpful!

@mboush123 Ай бұрын

Many thanks

@gautamudas Ай бұрын

Ahh throughout my career I was searching for this function 😮

@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