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!!
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.
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
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.
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!
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.
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: ruclips.net/video/2ViMm-wuM3U/видео.html
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
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
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.
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
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.
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
![YoungBoy Never Broke Again - Catch Me [Official Video]](http://i.ytimg.com/vi/KxwEXXFQMTY/mqdefault.jpg)
So far the best excel teacher I've seen! Thank you very much for great content 😊
Wow, thank you!
For the first time I’m not confused with vlookup thanks Mynda so much
Pam
So pleased to hear that, Pamela :-)
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!!
Thanks so much, Wayne!
Very nice teacher, her way of presenting is smooth and clear/ concise. Thanks
Thank you! 😃
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.
Yes, you are right. Doh!
a good excel teacher i have ever heard, thank u.
Wow, thank you!
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
Thanks, Patrick!
Thank you very much for the video Mynda. A great explanation, as always !!
Glad you liked it, Ivan!
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.
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!
Mam I learning many thing from your videos... Mam kindly upload more videos of power query ☺️
Great to hear, Anup! More PQ coming :-)
I love your videos! Can you make one talking about an email generator from excel?
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.
Great overview of VLOOKUP!
Glad you liked it, Doug!
I can’t think of any situation where “index match” isn’t a better option. Is there any?
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: ruclips.net/video/2ViMm-wuM3U/видео.html
Quiet easily explained. TY.
Glad I could help!
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
I recommend you use Power Query to compare two lists as explained here: www.myonlinetraininghub.com/excel-compare-two-lists
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
Glad it was helpful! Finding sample data is very difficult. I don't have any like you describe.
Thank you for letting me, your videos are 👌 btw
Thanks for useful lecture, It's really helpful.
Glad it was helpful, Muhammad!
Thank you very much for great content
Glad you enjoy it!
Amazing! Hoping to learn a lot from you 😊
Happy to hear that, Arun!
Hey u r amazing..can u make videos on analytics also basically showing focus improvement areas based on the current data..
Great Video!!!
Thank you so much!!!
Glad you liked it!
very nice 👍👍 Please include suggestions for Indonesian subtitles.
Thanks, Hanif. I don't choose the subtitle options, this is up to RUclips.
Thank you, your a life saver!!!
Happy to help!
Great video Mynda! Though I now really prefer XLOOKUP as u point out.
Cheers, Chris, me too :-)
Thanks for the great efforts.
I am unable to Download the Excel File, is there any issue with the link?
So sorry, Mutaz. File download is fixed.
Hello, please check the access to the Excel file as it cannot be downloaded. Thank you
Sorry, Jorge. File download is fixed.
Well Done Mynda
Cheers, Shakira!
Thank you so much! This So useful!
Pleased to hear that, Alejandro!
HI Mynda nice but why you select f4 to select dolor sign we also do this without f4
Thanks, Mayank! F4 is the keyboard shortcut to applying absolute referencing in formulas. It's quicker than typing in the dollar signs.
Game changer
Sure is, Benjamin!
Super useful 👍😁👍😁🙏
Glad you think so!
Thank you for knowledge of Excel . I want to request can you put link free download practice file 😁.
You're welcome! The link to the file is in the video description.
Nice 👍👍👍
Thanks for the visit!
Good 👍👍
Thank you! Cheers!
What's the difference with/without the dollar symbol being in the following positions: (C5), ($C5) and (E$4)?
The dollar symbol is used for absolute referencing as explained here: www.myonlinetraininghub.com/excel-absolute-references-the-missing-link
@@MyOnlineTrainingHub thank you so much. 😁
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.
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
Vlookup 😎 : it's done, and without dangers
Xlookup 👀 : I can't believe, she did that again...!!
Yes, XLOOKUP is the best!
Why would you choose to use Vlookup over Xlookup?
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.
@@MyOnlineTrainingHub Thanks, just wanted to check I hadn't missed something!
when I go to enter the formula =VLOOKUP it does not exist? is it possible this feature was turned off?
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
Index match vs xlookup ?
XLOOKUP every day :-)
you mean XLOOKUP? 😏
um? XLOOKUP: ruclips.net/video/2ViMm-wuM3U/видео.html