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 - https://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 - https://www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-c...
✅ Free VBA course - https://bit.ly/excel-vba-course
✅ Free Power Query Course - https://bit.ly/power-query-course
✅ Best Excel Books: https://trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...
#Excel #ExcelTips #ExcelTutorial #SumitBansal
Смотрите видео VLOOKUP vs XLOOKUP - Detailed Comparison with Examples онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь TrumpExcel 04 Июнь 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 8,661 раз и оно понравилось 386 людям.