Excel Battle: VLOOKUP vs XLOOKUP

File Download: https://www.excel-university.com/yt_u...

Which Microsoft Excel function is better, VLOOKUP or XLOOKUP? In this video, we'll put these two heavyweight functions into a 5 round main event. We will examine these key differences:
1 - Inserting a worksheet column breaks the formula
2 - Approximate match and exact match
3 - If error argument to handle errors
4 - Searching last to first (from the bottom of the table)
5 - Returning multiple columns


🔥 Are you trying to learn Microsoft Excel on YouTube? That's the slow way... Learn Excel the FAST way, find out how here 👉 https://www.excel-university.com/yt

Check out Excel PivotTables for Beginners (2023)    • Excel PivotTables for Beginners (2025)  

Subscribe here 👉 https://www.youtube.com/c/ExcelUniver... and turn on all notifications 🔔 for MS Excel time hacks that will make you more productive!

Watch VLOOKUP Hacks Playlist here    • VLOOKUP Hacks Series  

Watch VLOOKUP vs SUMIFS Playlist here    • VLOOKUP vs SUMIFS Series  

Watch Dynamic Arrays playlist here    • Dynamic Arrays Series  

Watch Treasure Maps playlist here    • Treasure Maps Series  

Watch Slow to Fast playlist here    • Slow to Fast Series  

Chapters in this video:
00:00 - Introduction
00:21 - Main Event
00:50 - Round 1
02:10 - Round 2
04:23 - Round 3
06:09 - Round 4
07:52 - Round 5