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.

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

#Excel #ExcelTips #ExcelTutorial #SumitBansal

[MuhammadArshad-vvxx]

I have learned the exact use of Vlookup and xlookup
welldone

[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.

[IvanCortinas_ES]

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

[PrincesDiana]

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

[jhankhanajani]

Thank you Sumit for amazing comparison !!

[kousikdey]

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

[gautamudas]

Ahh throughout my career I was searching for this function 😮

[MrFaisalgk]

New subscriber came after watching reels