VLOOKUP vs. XLOOKUP - What's the difference? (INDEX MATCH)

Learn the difference between VLOOKUP and XLOOKUP! In this complete tutorial, we cover everything you need to know about these two Excel functions and when you should use them.

🔗LINKS

📖Join Our Comprehensive Excel Training Program

**********

VLOOKUP vs. XLOOKUP - What's the difference (Index Match!)

In this video, we look at the key differences between Excel's XLOOKUP and VLOOKUP. Which one should you use and when? We answer this by showing you how to differentiate between the two, and discuss whether VLOOKUP is extinct…or just better suited to certain versions of Excel.

Thoughts/comments/suggestions/feedback? Leave them in the comments below ⬇️

**********

Related Content:

✅ XLOOKUP for Excel: Explained in 3 Minutes: • • Xlookup In Excel: Explained In 3 Minutes

✅ The New XLOOKUP Function: Compared to VLOOKUP & INDEX MATCH in Excel: • • New Xlookup Function: A Vlookup Compa...

✅ VLOOKUP Tutorial for Excel - Everything You Need To Know: • Excel Vlookup Tutorial - • Excel Vlookup Tutorial - Everything Y...

✅ INDEX MATCH Explained (An Alternative to VLOOKUP): • • How To Use Index Match As An Alternat...
#shorts #Excel #ExcelCampus #OfficeThemeColors #DataVisualization #ProductivityBoost #Microsoft

[tomfontanella]

Great video. You provide great answers but also know which questions are on our minds!

[garys]

I always enjoy your videos. Thanks Jon for sharing your knowledge. I appreciate that you did give us examples/reasons when VLookup might be the best solution.

[IvanCortinas_ES]

Great explanation Jon! Thank you for these interesting topics!

[richardhay]

I use only XLOOKUP and LOOKUP. Although I Use FILTER (FILTER) fot two-way. Before XL I used INDEX/MATCH for two-way, VLOOKUP for unsorted exact match and LOOKUP for approximate match and sorted exact match. LOOKUP is even older than VL and is usually easier to use than VL. Also it does lookup-left which VL does not do directly (although XL will.)

[patriciaduartesanina]

Thank you for this video. XLOOKUP has one more advantage: we can determine what it writes in the cell if a match is not found, thus avoiding an "error" input. This was a great step forward for me.

[darrylmorgan]

My Company Still Uses Excel 2016 So I Have To Use Index/Match And Vlookup But On My Personal PC(Microsoft 365) It's Xlookup All Day...Great Advice Thank You Jon :)

[barttitulaerexcelbart]

Thanks John. good idea that new Excel users also have to learn the "old" functions. As for the intimidating XLOOKUP, maybe start first with the much simpler and still effective LOOKUP ? As for the default value in VLOOKUP: every user should make an explicite decision if the result should be near or exact. Therefore I recommend always fill in this value.

[aliyuibnaliyu]

Excellent video...I was wondering how you created the presentation page with a pane on the left with the + sign. I will love if you could share a video on that as well

[Coffeedrinkerer]

Big help, I was about to convert all my vlookups to xlookups in a file I send externally. The backwards comparability limitation is good to know. I know they don’t have the latest excel so would have been a waste of time. I do love xlookup now though, especially the iferror argument. Saves so many nested ifs

[robertoivanballesteros]

how do you use xlookup if the column G email are mix up and you want to match them in the same row?

[jcook]

Great vid, Jon. Love the "ExcelPoint" slideshow. Just wonder how MS determined that VLOOKUP was the 3rd most used function?

[Nah]

Working in Tables means you don't have to worry about adding data. But if you work in ranges, your formulas
are always suspect.

[Nah]

ALWAYS work in TABLES. ALWAYS work in TABLES. ALWAYS work in TABLES. ALWAYS work in TABLES.