Excel VLOOKUP Function - Both Uses and Hidden Dangers!

[@zlatkozeco7951]

So far the best excel teacher I've seen! Thank you very much for great content 😊

[@MyOnlineTrainingHub]

Wow, thank you!

[@pamelamalthouse237]

For the first time I’m not confused with vlookup thanks Mynda so much Pam

[@MyOnlineTrainingHub]

So pleased to hear that, Pamela :-)

[@mehboobrehman01]

Very nice teacher, her way of presenting is smooth and clear/ concise. Thanks

[@MyOnlineTrainingHub]

Thank you! 😃

[@wayneedmondson1065]

Hi Mynda. Thanks for this thorough and clear lesson on VLOOKUP, its uses and pitfalls. VLOOKUP is feeling a bit old and dated now, but when used correctly, it can be a quick way to grab needed information from a lookup table. As always, good learning at your channel :)) Thumbs up!!

[@MyOnlineTrainingHub]

Thanks so much, Wayne!

[@ashutoshtripathi-rx3hs]

a good excel teacher i have ever heard, thank u.

[@MyOnlineTrainingHub]

Wow, thank you!

[@patrickschardt7724]

Another great video lesson. Even though I have 365 and am actually more familiar with the newer functions, I’m trying to learn the older methods/functions

[@MyOnlineTrainingHub]

Thanks, Patrick!

[@IvanCortinas_ES]

Thank you very much for the video Mynda. A great explanation, as always !!

[@MyOnlineTrainingHub]

Glad you liked it, Ivan!

[@IntegraQuality]

Hi Minda, great video, slight editing mistake at 4:28 - You needed to tab across to show the formula in cell F5 as opposed to E5, giving the range COLUMNS($H:J) returning column number 3.

[@MyOnlineTrainingHub]

Yes, you are right. Doh!

[@JORGEDELCASTILLOCORDERO]

Hello, please check the access to the Excel file as it cannot be downloaded. Thank you

[@MyOnlineTrainingHub]

Sorry, Jorge. File download is fixed.

[@jeffreystockdale8292]

I can’t think of any situation where “index match” isn’t a better option. Is there any?

[@MyOnlineTrainingHub]

Hi Jeffrey, VLOOKUP is a great place for beginners to start. INDEX & MATCH can be daunting to those new to formulas. Of course, nowadays we should all be using XLOOKUP: kzbin.info/www/bejne/aIfMfqBjrNqAabc

[@josuecastellanos2782]

I love your videos! Can you make one talking about an email generator from excel?

[@MyOnlineTrainingHub]

I'll keep it in mind. In the meantime here are some tutorials we've got on emailing from Excel: www.myonlinetraininghub.com/vba-to-create-pdf-from-excel-worksheet-then-email-it-with-outlook www.myonlinetraininghub.com/automating-emailing-pivot-table-reports Hope that helps.

[@DougHExcel]

Great overview of VLOOKUP!

[@MyOnlineTrainingHub]

Glad you liked it, Doug!

[@mayankbhola6700]

HI Mynda nice but why you select f4 to select dolor sign we also do this without f4

[@MyOnlineTrainingHub]

Thanks, Mayank! F4 is the keyboard shortcut to applying absolute referencing in formulas. It's quicker than typing in the dollar signs.

[@mayankbhatia1827]

Quiet easily explained. TY.

[@MyOnlineTrainingHub]

Glad I could help!

[@atharkhan9235]

Hi Would you please help to sort out my problem? I have a work sheet where VLOOKUP working properly but when i add a cell value that contain sheet name using formula =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255). No issue at all, adding sheet name manually in that cell. but adding with formula i got error.

[@MyOnlineTrainingHub]

Hard to say without seeing the file. Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum

[@zabdieldominguez5989]

Great Video!!! Thank you so much!!!

[@MyOnlineTrainingHub]

Glad you liked it!

[@arunrai2909]

Amazing! Hoping to learn a lot from you 😊

[@MyOnlineTrainingHub]

Happy to hear that, Arun!

[@Fshhady]

Thank you very much for great content

[@MyOnlineTrainingHub]

Glad you enjoy it!

[@mahj1982]

What's the difference with/without the dollar symbol being in the following positions: (C5), ($C5) and (E$4)?

[@MyOnlineTrainingHub]

The dollar symbol is used for absolute referencing as explained here: www.myonlinetraininghub.com/excel-absolute-references-the-missing-link

[@mahj1982]

@@MyOnlineTrainingHub thank you so much. 😁

[@mohamedaboobackersiddique7322]

Thanks for the tips. index and match is far better. to covert text to number i used to select the entire column and click text to column and click finish.

[@MyOnlineTrainingHub]

Yes, INDEX & MATCH gets around the limitations and dangers of VLOOKUP, but it can be quite daunting for many people, so I like to start teaching VLOOKUP and then move on from there. Great tip on converting text to numbers!

[@9458567]

Thanks for useful lecture, It's really helpful.

[@MyOnlineTrainingHub]

Glad it was helpful, Muhammad!

[@BeyondAnup]

Mam I learning many thing from your videos... Mam kindly upload more videos of power query ☺️

[@MyOnlineTrainingHub]

Great to hear, Anup! More PQ coming :-)

[@nifaefesolai5026]

These videos are amazing!! I am putting together a spread sheet that uses the VLOOKUP function to bring up sales id, personal details for customers and items purchased. Can you please help me find sample data of items that would be sold at an electronics store along with prices? For example computers, phones, accessories, printers etc. Thank you

[@MyOnlineTrainingHub]

Glad it was helpful! Finding sample data is very difficult. I don't have any like you describe.

[@nifaefesolai5026]

Thank you for letting me, your videos are 👌 btw

[@jayasam5898]

Hey u r amazing..can u make videos on analytics also basically showing focus improvement areas based on the current data..

[@DezirePestano]

Thank you, your a life saver!!!

[@MyOnlineTrainingHub]

Happy to help!

[@HanifTutorial]

very nice 👍👍 Please include suggestions for Indonesian subtitles.

[@MyOnlineTrainingHub]

Thanks, Hanif. I don't choose the subtitle options, this is up to KZbin.

[@Xaneke88]

Amazing, thank you. I'm using vlookup to compare two sheets and find the differences. But how can I highlight the differences to analyse why/how the data has changed? When I use the vlookup with conditional formatting the document gets massively big. Is there an easy way to compare the data, highlight the difference and extract that data to analyse? Many thanks

[@MyOnlineTrainingHub]

I recommend you use Power Query to compare two lists as explained here: www.myonlinetraininghub.com/excel-compare-two-lists

[@parkwaypony1914]

when I go to enter the formula =VLOOKUP it does not exist? is it possible this feature was turned off?

[@MyOnlineTrainingHub]

It's definitely not turned off. Are you trying to use VLOOKUP in Power Query? Please post your question and screenshots on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum

[@Al3jov]

Thank you so much! This So useful!

[@MyOnlineTrainingHub]

Pleased to hear that, Alejandro!

[@MrDhunpagla]

Super useful 👍😁👍😁🙏

[@MyOnlineTrainingHub]

Glad you think so!

[@chrism9037]

Great video Mynda! Though I now really prefer XLOOKUP as u point out.

[@MyOnlineTrainingHub]

Cheers, Chris, me too :-)

[@shakiraasfoor7599]

Well Done Mynda

[@MyOnlineTrainingHub]

Cheers, Shakira!

[@AccountingandQuickbooks]

Nice 👍👍👍

[@MyOnlineTrainingHub]

Thanks for the visit!

[@mutazelsadig4006]

Thanks for the great efforts. I am unable to Download the Excel File, is there any issue with the link?

[@MyOnlineTrainingHub]

So sorry, Mutaz. File download is fixed.

[@mero4goal435]

Thank you for knowledge of Excel . I want to request can you put link free download practice file 😁.

[@MyOnlineTrainingHub]

You're welcome! The link to the file is in the video description.

[@HanifTutorial]

Good 👍👍

[@MyOnlineTrainingHub]

Thank you! Cheers!

[@howardsmith2]

Why would you choose to use Vlookup over Xlookup?

[@MyOnlineTrainingHub]

The only reason you'd choose to use VLOOKUP is if you have a version of Excel that doesn't have XLOOKUP...i.e. Excel 2019 and earlier, which is the vast majority of current Excel users.

[@howardsmith2]

@@MyOnlineTrainingHub Thanks, just wanted to check I hadn't missed something!

[@MohdSaifoulAzuan]

Index match vs xlookup ?

[@MyOnlineTrainingHub]

XLOOKUP every day :-)

[@benjaminkeyrose4294]

Game changer

[@MyOnlineTrainingHub]

Sure is, Benjamin!

[@merbouni]

Vlookup 😎 : it's done, and without dangers Xlookup 👀 : I can't believe, she did that again...!!

[@MyOnlineTrainingHub]

Yes, XLOOKUP is the best!

[@sauceguy19]

you mean XLOOKUP? 😏

[@MyOnlineTrainingHub]

um? XLOOKUP: kzbin.info/www/bejne/aIfMfqBjrNqAabc