Stop using VLOOKUP in Excel. Switch to INDEX MATCH

Video quality	The size	Download

Information Stop using VLOOKUP in Excel. Switch to INDEX MATCH

Title	:	Stop using VLOOKUP in Excel. Switch to INDEX MATCH
Lasting	:	11.05
Date of publication	:
Views	:	2,5 jt

Can you also make video on Xlookup!?
Comment from : @prabalthakur1202

Exactly!! Thanks :)
Comment from : @AleksandarGocanin-w1z

Brilliant! Did exactly what I needed I tried VLOOKUP and it wasn't working, but this worked perfectly
Comment from : @JenniNJeff

Clear and helpful explanations of both VLOOKUP and INDEX-MATCH! Many thanks!
Comment from : @WalterEPond

Sure glad I saved this video Watched it once sometime ago and it was great, rewatched it again to brush up on this excel problem and it was just as well described and useful as I remember it!
Comment from : @daurgo2001

Thank you so much It helped a lot Please keep posting more informative videos like this
Comment from : @amirhassan1100

what about xlookup? doesnt it fix the problem with first colum and less complicated than index match in that regard?
Comment from : @smilko00

I have seen couple of videos of this index match function but couldn't understand properly Now the way you explained it, I believe I'm going to remember it for a long time now Thanks for such video
Comment from : @msh3309

many thanks
Comment from : @judasmurdah9971

Combine D and E use …
Comment from : @Traveleverywhere-o2c

can you do this in 3 different google sheets? with google docs
Comment from : @IAmInevitable1337

Instead of writing Excel formulas I use Python scripts
Comment from : @manzana5713

Can you show example for index match on two criteria formula? This is great, thank you
Comment from : @turbalejo4999

super clear and easy to understand!
Comment from : @thebesttechnical3608

Dumb dumb ?
Comment from : @fragwaves

I'm building out a website and to bulk import my items I use a csv file I was dreading having to pull data from one of the excel documents as I was going to have to use a vlookup I wasted a whole day trying to get the vlookup to workbr brToday I was going to try again I’m glad that I was procrastinating and opened up my YouTube page first I'm not sure how your video got on my home page, but I'm glad it didbr brI didn't try the vlookup today Instead, I opened your video, and I’m glad I did you saved me another day of not getting anything done Your steps are very clear as you explain them and what you should expect to see happen as you complete each step Even with the data being in two different workbooks I was able to get the data on the first try with your steps Thank you for such a great video
Comment from : @CozyCottageGoods

Its always better to do things the hard way instead of the easiest way that works best 97 of the time Just use vlookup unless you need to do something that most people will never need Ive been a business analyst 10 years using excel daily and only used Index Match less than 10 times in my entire career Its so confusing that you will be lost if you need to adjust the formula later on If your a masochist, this video is for you
Comment from : @richardcampbell7055

this is so much better and well explained thank you so much
Comment from : @pollamollaza

Huge!, never using Vlookup again, Great video!
Comment from : @Dalfrex

thank youuuu
Comment from : @PoncoSisworo

Why Waste our time by your explanation of vLookup and just tell us HOW the heck Machup works!!!! Your instruction includes unnecessary information to apparently impress us with how much you know I can tell you are very smart so just be respectful of our time and exclude the unnecessary info and show how it is to be done SIMPLY
Comment from : @charlesphillips7731

4:20 what's the logic here?
Comment from : @dtsect

Great help, couldn't figure it out with Vlookup, but this worked 100
Comment from : @danushajayarathna8859

You make this so easy to undertand Is there a way to update multiple columns at once?
Comment from : @TheMysticRavenStore-kl3ni

Use vlookup many times a day This video has changed my life for the better! Wow! Thanks!!!!
Comment from : @Hameloto

Hi, I would like to automatically fill out a table using data from two other sheets Basically, copying cells from 3 columns from two separate sheets but the challenge is to copy those cells only if the cell value of one of the sheets matches the value from two different tabs of the other sheet I am willing to pay you to help me with this Let me know if you can help
Comment from : @julianaramburo2023

Can you please help me with formula to get the row data based on criteria in to other sheet
Comment from : @yunusbagban2766

Simple and well explained Able to solve like a magic
Comment from : @ContractorInsight

THANKS BROTHERRbrI SO HAPPY TO LEARN HERE
Comment from : @AliAttact

This is a game changer Thank you so much!
Comment from : @oresource

And just like that, Vlookup is toast! Thanks so much for this! 🙏🏽
Comment from : @christophermoreno1615

can we get a sample document or exercise files to use as practice?
Comment from : @C901-r8i

INDEX is wonky, I like OFFSET MATCH combo
Comment from : @marcw5492

But this seems more complicated that just using Vlookup You have to do 3 times the work it seems I agree with @thinkleclt
Comment from : @solarwinds-

Thank you so muchhhh<3 !!! God Bless youuu!!
Comment from : @lovetally

I've often used OFFSET and MATCH for this purpose Good to know INDEX will save me a couple characters
Comment from : @SeanBellForgen

It was great help, thank you
Comment from : @funtimewithaaron370

Yes index and match does seem like it is better than vlookup, but not nearly as much as you overhyped it and downplayed vlookup You can use match with vlookup, it is more restrictive but can be done
Comment from : @johnm4141

Indexmatch just work in one colum with same place on 2nd colum its showing spill! Why
Comment from : @marwahleo2750

This is great, thank you!
Comment from : @MakingDataUseful

Combining Vlookup and Match will make it dynamic
Comment from : @aristoalexius

Dose Xlookup do the same job? and how?
Comment from : @ssdusd

That is realy Awesome!
Comment from : @ssdusd

Thanks for sharing Really helpful
Comment from : @ActiveLearningforAll

Very valuable contribution! Many thanksbrA quick aside: parentheSIS is the singular, parentheSES is the plural You can't have a single parenthesee
Comment from : @JerGol

Bha ha this is funny There is nothing simple or easy about Index Match🤣🤣
Comment from : @KalahariJack

Thanks If I have many result(quntitys) and I want total it how can do it ?
Comment from : @ismsult

Thanks
Comment from : @kvelez

Nice
Comment from : @marufkarimov9942

Fucking lifesaver
Comment from : @jakobbrinchmann646

How is this easier lol I get that vlookup has its issues but this is not easier
Comment from : @worldtraveler7296

I have a commission-based job I get tons of deposits throughout the month from many companies Do you think Index Match is a good tool to try to audit commissions? Or is there something better-suited? I tell youour entire industry sucks for the low man on the totem pole when it comes to auditing our sales and commissions As a matter of fact, I know no one who audits because it is simply too challenging
Comment from : @amandamatthews4545

LOVE IT! THANKS FOR YOUR GUIDANCE
Comment from : @makuibellezaholistica

Great video! I ran into a problem when I was trying to reference a cell for the Match Lookup_Value that contained a formula Couldn't seem to find a way around that problem
Comment from : @harrymickunas36

thanks for help, finally i found the formula
Comment from : @aldhydwicahyo360

index match works well than vloookup i'm battling for a week using vlookup although it finds some data in a rows but some rows it can't even find so i have to repeat the formula again and again thanks bro!!!
Comment from : @jeremylatayan1074

One thing that frustrates me the most about vlookup is when I forget to put FALSE in the last parameter and I get unexpected results as a result The second thing is the performance when I use tens of thousands of rows that all need to lookup a key on some other sheet it sometimes makes all operations slow such that you end up having to disable automatic recalculation because excel becomes to painful to use
Comment from : @drescherjm

THX!
Comment from : @JahWas1

Looks like XLOOKUP would do it in a second 🤔
Comment from : @kotrynele

Thoughts on Xlookup vs Index and Match?
Comment from : @Yazan8565

NICE!
Comment from : @thebuffalogoldguru

That was so helpful Many Thanks
Comment from : @gardenlighting-barrysluite7505

Fantastic
Comment from : @arjunnath2896

I get more errors with this formula, rather vlookup so
Comment from : @JAswoosh

very simple and easy tutorial
Comment from : @worldofjeeva5279

Thank you so much much for this video This example is extremely similar to what I need to do for work all the time in education I was able to learn both v look up and index match here in about 10 minutes 🎉
Comment from : @april-michellevalmont2120

👍
Comment from : @graceminiano8325

Neither VLOOKUP nor MATCH is working on the data I'm using Both return #N/A and no amount of formatting makes a difference I'm baffled and suppose I just have to go back to manual matching by hand for some things
Comment from : @Endymion766

For anyone watching in 2024, the xlookup function does all of this and is much simpler to use and follow
Comment from : @2005StangMan

a huge thank you!! this is very effective
Comment from : @mariachristinapaine102

how do I disable the option to detect duplicate values in excel - how do I disable this option - I want to have duplicate values????
Comment from : @electrovoltmce

Did I tell you how much time this saved me I had to work with over a million records, 10 files of 100000 each, 4 times Without this I would have died before completing my work Thank you!
Comment from : @johngraham6506

No way!!! That’s crazy I am a believer now Thank you
Comment from : @aandino9906

open parentheses or open bracket?
Comment from : @AbyssalPlain

Can you use Index Match for referencing the Grand Total in a PIvot Table?
Comment from : @glenndm1

Thanks this was a huge help wonder if i am supposed to acknowledge you in my thesis now 🤔
Comment from : @clueless6763

Couldn't you just use xlookup to do the same thing?
Comment from : @TheDocdreamer

I think the struggle I have with INDEX MATCH explanations is that it is described as a substitute for VLOOKUP Many times when I try to use IM I have many issues such as the "full name" in your example being associated with multiple IDs If George Washington also had customer 1004 for some reason, IM stops at the first match and would create issues
Comment from : @ryanschuman3952

Thank you so much for to this breakdown! I'll definitely be using these functions a lot more in the future : )
Comment from : @adhdru

I use Xlookup
Comment from : @lastardubeninoo

This argument is completely moot with XLOOKUP coming to the scene in 2020
Comment from : @Cassandra519

vlookup is a very useful formula and should not be stopped 👎
Comment from : @kylesmyle

how is this faster
Comment from : @jrk1403

can excel take into account weeks till runout versus today
Comment from : @FlorMartinezMejia-k4z

Thanks a lot
Comment from : @cristiandcastellanosg3924

XLOOKUP murders INDEX MATCH & VLOOKUP
Comment from : @fletch9702

6:00 What if you move the table so customer ID is no longer on column H? Maybe instead do Table2[Customer ID] so it auto adjust if you move the table?
Comment from : @GmanMilli

Great video demonstrating a more flexible alternative to VLOOKUP() formulas br brMy personal preference is to use Power Query, which eliminates the use of formulas entirely
Comment from : @serdip