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
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.
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!
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: ua-cam.com/video/2ViMm-wuM3U/v-deo.html
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
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
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
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
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.
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!
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!
Very nice teacher, her way of presenting is smooth and clear/ concise. Thanks
Thank you! 😃
Quiet easily explained. TY.
Glad I could help!
a good excel teacher i have ever heard, thank u.
Wow, thank you!
Thank you very much for the video Mynda. A great explanation, as always !!
Glad you liked it, Ivan!
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!
Great Video!!!
Thank you so much!!!
Glad you liked it!
Thank you very much for great content
Glad you enjoy it!
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!
Hello, please check the access to the Excel file as it cannot be downloaded. Thank you
Sorry, Jorge. File download is fixed.
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!
very nice 👍👍 Please include suggestions for Indonesian subtitles.
Thanks, Hanif. I don't choose the subtitle options, this is up to UA-cam.
Hey u r amazing..can u make videos on analytics also basically showing focus improvement areas based on the current data..
Amazing! Hoping to learn a lot from you 😊
Happy to hear that, Arun!
Thank you, your a life saver!!!
Happy to help!
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: ua-cam.com/video/2ViMm-wuM3U/v-deo.html
Thanks for useful lecture, It's really helpful.
Glad it was helpful, Muhammad!
Mam I learning many thing from your videos... Mam kindly upload more videos of power query ☺️
Great to hear, Anup! More PQ coming :-)
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
Well Done Mynda
Cheers, Shakira!
Thank you so much! This So useful!
Pleased to hear that, Alejandro!
Great video Mynda! Though I now really prefer XLOOKUP as u point out.
Cheers, Chris, me too :-)
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.
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
Super useful 👍😁👍😁🙏
Glad you think so!
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.
Nice 👍👍👍
Thanks for the visit!
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. 😁
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.
Good 👍👍
Thank you! Cheers!
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
Game changer
Sure is, Benjamin!
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 :-)
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!
Vlookup 😎 : it's done, and without dangers
Xlookup 👀 : I can't believe, she did that again...!!
Yes, XLOOKUP is the best!
you mean XLOOKUP? 😏
um? XLOOKUP: ua-cam.com/video/2ViMm-wuM3U/v-deo.html