Vlookup vs Index and Match in Excel by Chris Menard

There are many reasons to use Index and Match over Vlookup in Excel. Two reasons are if you insert or delete a column in your data, Vlookup will be incorrect. The 2nd reason is Vlookup will only look to the right.


Chris Menard offers instructor-led training and his Excel classes are available online.

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[lalbabukurmi]

You make it so, simple sir. I was wandering on the internet for the simple way to use it on large file . Very useful . Thanks again.

[mistofstars]

thank you! I finally understood why this approach is superior to vlookup :)

[edusboy]

I enjoy how you break down and simplify the concepts in your videos. Thank you!

[callendeer]

"vlookuo only go to the right."

Thanks sir i'm sold

[Queen-xnlm]

This function is a lifesaver. I use some really large spreadsheets in accounting and vlookups can be a pain in the behind especially when you have deadlines to meet. Thanks for your very clear explanation!

[Wcbssg]

Most easier guide ever seen! Good job and appreciate your sharing!

[simdee]

Thanks for this video Chris - super informative and it helped me to build the report I needed. Great job!

[leticiawregeholdefehr]

I am loving your videos. Congratulation. Great way to keep up to date on excel.

[RakeshSharma-ydhk]

nice. Calm voice and calm presentation...

[delick]

Thank you for the video. I feel so powerful now I have acquired this knowledge

[cassandrecavalier]

Thank you for this video! Keep up the good work!

[Ryan-dclj]

Very helpful - thanks! I'll use this today :) If the dataset was a Table, and a column was inserted, wouldn't the vLookUp adjust?

[shoaibtahir]

Thanks. The live example really helped make sense of the formulea.
Just so you know, A title like "Stop using Vlookup, here's why" would have beem more engaging for this video.

[hoople]

or you can use tables and use the column function and column name

[jennyng-tai]

I'm here wanting to know the difference of the 2 functions. And 3:03 and 5:26 answer my question. Thank you!

[fulgensnocte]

Hi, can anybody help me on how to make the filter that stand alone like the one in the video?
Like the one in french cell, can change it to another country by click in it 🙏

[ddiq]

Your explaining vlookup and index matching, but you deleted those 4 cells in a square individually ? with your mouse ? Lol but seriously great explanation

[voodoochili]

Good explanation, but you could explain more WHY/HOW index/match can look from right to left when columns are inserted.

[ExaltedDuck]

IMHO the best selling point on adopting the apparent complexity of index/match (other than the much more flexible usage) is the significantly better resource usage than vlookup/hlookup.