How To Use Index Match As An Alternative To Vlookup

preview_player
Показать описание

You can follow along with the video and practice writing the formulas. The Excel file also includes my cheat sheet for writing the formulas.

I explain the two main benefits of INDEX MATCH over VLOOKUP. This includes:

The ability to return a value from a column to the left/above.
Separate columns for the lookup and return ranges.
We also look at the most common error that the formula returns and how to prevent it.

The new XLOOKUP function is another alternative to VLOOKUP and INDEX MATCH. Check out my other videos for more details on that.

#MsExcel #ExcelCampus
00:00 Introduction
00:39 Benefits of Index Match
02:23 Match Function
06:02 Index Function
09:09 Index Match
12:20 Index Match to the Left
15:13 Most Common Error
Рекомендации по теме
Комментарии
Автор

That's the best one I have came through... and you exactly know what we need. A 'Thanks' would just be a very little expression of my gratefulness.

LearningPoint
Автор

As an instructor, showing things that go wrong first gives students a better sense of WHY they need to learn an alternative or learn it the way its supposed to work. Some bad habits get so ingrained that unless theres a reason, they keep doing things the old way. So kudos to you.

garynair
Автор

i have to say this is by far THE BEST tutorial on index match i have seen. So clear, so simple to understand. Your teaching style and accompanying graphics and cheat sheets make it easy to follow. Thank you!!!

szt
Автор

I've seen other Excel teaching videos. This guy is the best in every way, especially on complex functions. The materials he provided were excellent!!

eluxury
Автор

I feel more and more like a magician every time I watch your tutorials. Great content!

mleanot
Автор

This has to be the best channel for excel tutorials. Very clear and easy steps to follow. You don't over complicate it. Thank you

priscillapedraza
Автор

This is the best explanation ever. Thank you - I'm using it to compare inventory audit sheets to a list of 26, 000 items unaccounted for. Joy. This makes that task digestible! Thank you again.

robertjones
Автор

I watched several videos before stumbling upon this one. This is the best and easy tutorial on index matching. Thank you Jon

prakashviswanathan
Автор

I must say this is the best index match explanation I've seen. Seriously. Thank you.

lanista
Автор

I am a very competent Excel user when people give good wxplanaon how to do something. I've found that most tutorials go to fast or don't explain every step. I felt you did a great job of explaining and I appreciate what you were able to teach. Thank you.

cherposton
Автор

I have never come across any excel tutorial YouTube video that is as informative and easy to understand as yours. BIG THANK YOU for sharing all these VALUABLE information to the viewers. I've always struggled to understand these formulas as I never learnt them in my uni, but I need to use them at workplace. THANKS AGAIN!

sweza
Автор

I just reviewed the accompanying workbook you provided. I believe your generosity with your knowledge to be one of the finer examples of what the internet was intended to be and I loathe the times I have fallen short of that expectation. I truly appreciate you, your work, and for reminding me to be human on the internet.

ddigwell
Автор

OMG, thank you SO much for this video! Back story: I used INDEX MATCH several years ago at a previous job, many times for a few weeks and then not at all since then. Now at my new job I absolutely _KNEW_ that this was the function I needed and I read several blogs and watched some videos about how to do it, but nothing was working right. This video explained it all so well and 10 minutes after watching it I solved the issue I was having for weeks and you've saved *THANK YOU SO

elisabethwestner
Автор

The best and most explicit tutorial of Excel that I have found so far. A lot of thumbs up! Thank you so very much Jon.

cathykoalapan
Автор

I think this is probably the best Excel training video I have ever watched in my life (and I've watched a LOT of them). Thank you for the spreadsheet download to follow along, for being so clear and for highlighting everything you do (and for the added "Anchor" and "Tab into" tips). You are a great teacher! This helped me understand so much better!

Mburgdorf
Автор

I've watched many videos of excel,
But this guy teaching way is so amazing
The way he explain excel function/formula is so helpful

mushtaquejaffar
Автор

LOVED THE CONTENT AND YOU EXPLAINATION ALOT, ONE MORE THING I HAVE NOTICED IS THE WAY YOU ARRANGE THE THOUGHTS TO INSTALL THE FORMULATS CORRECTLY IN OUR MINDS THANKS ALOT

Mostafaahmedheshmat
Автор

I spent an hour googling and I only watched your video for 2 mins and fixed the problem ✨🎉 THANK YOU

selenediorr
Автор

By minute 4 I learned 3 different shortcuts that I have never heard of before. Super clear presentation, awesome video. Thank you.

madisonthompkins
Автор

This is such a great tutorial on INDEX MATCH. I love that this broke down each function's definition and even put the requirements in layman's term for anyone without coding experience. The snippet about using data validation for pulling up values was brilliant. Definitely is another great idea for my toolbox. Thank you for the awesome, well-articulated video.

Felix-ouxe