Data Analyst Explains When to Use VLOOKUP vs XLOOKUP vs INDEX MATCH

┋Professional Certificates┋

┋Timestamps┋

00:00 Intro
00:41 VLOOKUP
06:19 INDEX MATCH
15:35 XLOOKUP
19:18 Outro

[xaerialconsultancy]

Wanted to know these for years. Took 20 mins and now I know. Thank you Mo!!!

[aisx]

1 - I disagree that if you are looking left or right that you should be using either vLookup or Index Match, you should just use index match in both cases.

2 - XLookup is easier for new users to audit the formula, so if its a simple file or references, I would just use Xlookup

3 - If you are auditing different worksheets, and you are referencing a cell in one worksheet, and searching for it in another worksheet, and you want to audit this row by row to make sure whatever its returning is correct, I would use Index Match in every case.

Why? - Because you can press Ctrl + [ to take you to the column that its referencing without using the mouse, and then you can press Ctrl + G then press enter to take you back to the index match formula

Also, Index match is the most computationally efficient

[AlHenley-bm]

What a fantastic tutorial, Mo. I am so impressed on how EASY and clear your explanation was. Instead of having us memorize formulas, you really explained the components of it in a way that just clicked for me. I appreciate your channel.

[carltonshank]

Thanks Mo, Finally a tutorial that cuts right to the chase... your explanation is "spot on" - you have a skill in explaining in simple terms that really connect with me.

[patricklacey]

Thumbs up for that "F4" callout, I was struggling to fix my fill option and you saved me! Excellent video.

[BemdooDzoho-rmsx]

Thanks a lot Mo. I just built an outstanding bill of material configuration template to complete my internship project. Couldn't be more grateful!

[Asad-Niazi]

you explained it as an art. My interest in learning excel increased 2x. thank you Mo.🤩

[rubymenonbrainsmartdesign]

Excellent video! You clearly explain each function with the pros, cons, and use cases for each. Well done! I learned a lot. Thank you!

[RigorFortis]

Best tutorial I've seen. Very effective to make us understand which formula to use or not. Excel always felt to me like a mad scientist's laboratory.

[lamishelall]

Great content, as a person starting a career in data analytics all over, your content is a great help, keep up your hard-working, thanks 😍

[dnyandeosomawanshi]

Thanks Mo. You are great - explained in very simple manner easy to understand for all.🙏

[jhow]

Xlookup is so much easier than Index Match.

[chicoamorim]

I had troubles with this exact problem about a week ago, took me ages to figure ir out, most of the explanations were not as easy as this one, i wish i had found this video sooner

[mubeenahmad]

Hey Mo. Thank you for sharing this informative video. I have been using MS Excel for quite some time for my regular office stuff, and now want to learn it as a data analyst. I googled for the courses but ended up confused that which one to choose. I would appreciate if you could share a link to the course to learn MS EXCEL in detail. Thanks

[DucatiSydney]

Can I get a link to download that table?

[protocolwonder]

Awesome tutorial. This is a mighty impact.

[trayjunie]

this might be a stupid question, but why do you want to lock in (F4) the look up range? What happens thats different if you don't?

[grandmakittyhamilton]

I have 2 separate workbooks, Same ID#'s on both but in different order, (some are missing on one SS). I have a phone number associated with the ID# on one sheet and I want to add that phone number in a column associated to the ID# on the other SS. What is the best method to do this? Do you have a video that explain this process. Hope this makes sense :-) Thanks for your help!

[John-kdbf]

I'm confused about your VLOOKUP formula example which refers back to the range in the orders table. It looks like you are hard-coding the order table range, but couldn't the order table add new rows by the user as new orders get recorded? Can you set the range to include the current selection plus any future additional rows that get created?

[Prakhao]

❤thanks for your sharing this video. It's valuable to me 😊😊