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 - [ Ссылка ]

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 - [ Ссылка ]

✅ Free Excel Course (Basic to Advanced) - [ Ссылка ]
✅ Free Dashboard Course - [ Ссылка ]
✅ Free VBA course - [ Ссылка ]
✅ Free Power Query Course - [ Ссылка ]
✅ Best Excel Books: [ Ссылка ]

Subscribe to get awesome Excel Tips every week: [ Ссылка ]

#Excel #ExcelTips #ExcelTutorial #SumitBansal

свернуть