Excel VLOOKUP Function - Both Uses and Hidden Dangers!

The Excel VLOOKUP function has two ways it can be used, but most people only know one way. Also, many users make a huge mistake which can end result in monumental errors. In this video I not only make VLOOKUP fomulas easy, but I also make you aware of the dangers.

0:39 VLOOKUP Exact Match
2:48 Dynamic Column Reference with COLUMNS
4:59 Dynamic Column Reference with MATCH
6:57 VLOOKUP Approximate Match
8:50 Causes of Common Errors
10:05 Dangers of VLOOKUP

[pamelamalthouse]

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

[mehboobrehman]

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

[IvanCortinas_ES]

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

[patrickschardt]

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

[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.

[zabdieldominguez]

Great Video!!!

Thank you so much!!!

[josuecastellanos]

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

[mohamedaboobackersiddique]

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.

[anupdas]

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

[HanifTutorial]

very nice 👍👍 Please include suggestions for Indonesian subtitles.

[jeffreystockdale]

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

[JORGEDELCASTILLOCORDERO]

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

Thanks for useful lecture, It's really helpful.

[arunrai]

Amazing! Hoping to learn a lot from you 😊

[jayasam]

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

[chrism]

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

[nifaefesolai]

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

[mayankbhola]

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

[mahj]

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

[merogoal]

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