VLOOKUP vs XLOOKUP - Detailed Comparison with Examples

Video Description

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/8245sbbp534rxkyv715vh/XLOOKUP-vs-VLOOKUP.xlsx?rlkey=7km32mag87r6gbbk0f70614sy&dl=1 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-course ✅ 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/trumpexcel?sub_confirmation=1 #Excel #ExcelTips #ExcelTutorial #SumitBansal