VLOOKUP and XLOOKUP: we cover everything you need to know about these two Excel functions and when you should use them. DOWNLOAD THE WORKBOOK ► https://www.excelcampus.com/functions/vlookup-vs-xlookup/

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

In this video, we look at the key differences between Excel's XLOOKUP and VLOOKUP. We show you how to differentiate between the two, and discuss whether VLOOKUP is extinct…or just better suited to certain versions of Excel.

LINKS

Get free weekly Excel tips: https://www.excelcampus.com/newsletter/

Free 60-minute Excel training session: https://www.excelcampus.com/blueprint

Join Our Comprehensive Excel Training Program: https://www.excelcampus.com/elevate

Related Content:

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

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

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

INDEX MATCH Explained (An Alternative to VLOOKUP): • • How To Use Index Match As An Alternat...

00:00 Introduction
00:38 Drop The Anchor
02:15 The Last Argument
03:09 The Invisible Error
04:22 Naked VlookUps First
05:44 VlookUp os Index Match or XlookUp
08:28 Keyboard Shortcuts
09:20 Avoid Formula Stuffing

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