Kia Ora! I'm a Kiwi living in Sweden working on a project where this information is exactly what I need. Its great to find it, but after 5 years away it is great to have the quick lesson on my accent :) Thank you very much!!
Kia ora Marty! I hope you're doing well up in Sweden. Lovely to read your message, and so great the video helped you. I get quick a few interesting comments about my Kiwi accent. Not all of them as nice as yours LOL! Take care, Nga mihi nui. Sharyn
Jesus...I was so confused until I found this. Not the exact thing I was after, but gave me an approximate idea on what I should be doing. Crystal clear explanation. Thank you so, so much.
THANK YOU! I have struggled so much with this from other videos and gave up and decided to try again, this was SO easy to follow!! I was so excited when it worked for me! :)
Been looking to solve my challenge for the last hour and have been driven mad by the long list of clowns giving advice. Being under the cosh, I needed a solution fast...! Solved by your brilliant video, thanks Sharyn! Looking forward to watching your other video's.
Please advise me. I am trying to do a check on just the figure. The invoice between the 2 worksheet is exactly the same. Only the amount is different. Will Vlookup show #N/A on the amount if invoice number is exactly the same for both worksheet??
Hi Judy. As long as the VLOOKUP can find a match between the 2 worksheets it will return the figure. If you are trying to do a match based on the Invoice number AND the figure, you might like to check our my blog on how to do this excelatwork.co.nz/2021/08/22/vlookup-multiple-criteria-in-excel/
Question: I think me having duplicate values is what is causing my problems; however I need a way to return a value from sheet 1 based on a common item # in sheet 2. I do have multiple duplicate item #'s in sheet 2 and want to return a corresponding value from sheet 1 every time Excel find the numbers. What other function can I use if not VLOOKUP?
Finally someone with a problem statement. Thanks a ton Sharyn. Please can I ask a few questions 1. We have now Index and Match and power query as well so why VLook Up 2. What are the other functions which are mostly useful with Vlook up ?again thank you. Are you from New Zealand ?
Such a great question! Index and Match and Power Query are fantastic tools. However sadly not many people actually know about them. 9 times out of 10 I'm asked to teach people how to use VLOOKUP, mainly due to legacy files that are full of VLOOKUP formulas AND so many employers are still asking specifically for VLOOKUP skills when hiring. So I can't see VLOOKUP going away any time soon. Although I'm trying really hard to show as many people as I can the new XLOOKUP function (video coming soon) which is AMAZING! And yes! I'm from New Zealand. Kia ora my friend!! 😀
Sorry, I didn’t answer your 2nd question. There are just so many. Definitely the TRIM function (video on this due out next week), the LEFT, RIGHT and MID functions and definitely the VALUE function. All fantastic functions to have in your toolbox to ensure your lookup functions work 👍
I only have columns that have duplicates to work with, VLOOKUP is not working, what else can I use? 500 names in one, 141 in the other, I need to math which are in both. Thanks
Hi Jo. You might like to give Conditional Formatting a go. Check out this blog trumpexcel.com/compare-two-columns/ The steps under the heading 'Example: Compare Two Columns and Highlight Matching Data' may be what you need. I hope it helps.
@@ExcelatWork Eu estou muito feliz por sua resposta. Estar em contato com você é motivo de grande felicidade. Muito obrigado e parabéns por seu excelente vídeo. Você é maravilhosa. Um grande abraço. Que Deus lhe abençoe, sempre.
Hi Judy. It could be that the Error Checking option has been turned off. Please check this blog out excelribbon.tips.net/T010655_Turning_Off_Error_Checking.html I hope it helps.
You're right Andrew. I need to do an additional video on XLOOKUP. Amazingly I'm still training people who don't yet have the XLOOKUP function so this video still has a few more miles left in her 😊
I have to compare two files at work, the vendor file has over 6,000 entries of item number, cost, regular price, sale price, description, etc. The items we carry at our store is only close to 700 items. I have to compare these two files and update any changes into our accounting system (lightspeed). I can export the files we carry from lightspeed into an excel file. and can download the vendor file into excel. So it sounds like I need to put both files into a work book, and try doing a vlookup based on the common factor of the item number. Seems I will need to sort each sheet by item number, lowest to highest to start. then start the comparison. Can you give me a direction from here how to complete the vlookup? Or is the the best method to do the comparisons? I have noticed other videos using IF formulas, and seems a bit confusing, since I don't know anything about these formulas either. I appreciate any direction you may have . Judy
Hi Judy. Apologies for the slow reply. Sounds like you are on track. You don't need to sort the files if you are using VLOOKUP with a 'false' argument at the end of the function. If you follow this video and use the common factor of the item number for the lookup_value you should have success, e.g. the item number would replace the Invoice number example I use in the video. From what you have described to me I would recommend VLOOKUP instead of using IF functions. 😀
Though I appreciate your effort, not being able to explain 'absolute' with the F4 key or Fn+F4 on a Mac, you're kind of leaving out the point. This should be commented on vs... just saying to 'add in a $' with barely an explanation.
Let Sharyn help you learn how to use VLOOKUP to compare two lists or columns of data (download the exercise file to follow along).
Kia Ora!
I'm a Kiwi living in Sweden working on a project where this information is exactly what I need. Its great to find it, but after 5 years away it is great to have the quick lesson on my accent :)
Thank you very much!!
Kia ora Marty! I hope you're doing well up in Sweden. Lovely to read your message, and so great the video helped you. I get quick a few interesting comments about my Kiwi accent. Not all of them as nice as yours LOL! Take care, Nga mihi nui. Sharyn
I hope you know you just helped me 3 years later! Thank youuuu
I'm so glad! Thank you for letting me know!! 😀
You explained vlookup in nice and simple way, wow
Thanks, I'm glad you found it helpful!
I think you were the first person that explained this in a way that makes sense 👌🏽
Thank you! I'm so glad you found it helpful 😀
Big laugh for Ms Lagah
This is most professional how to video for microsoft excel - she talks like a journalist - and the background music in the intro was something else
Thanks Chris! So glad you enjoyed it 😀
Finally found a tutorial that easy to understand. Big thanks!
Thank you! I'm so glad it helped! 😀
You are fantastic. This was extremely helpful after spending hours trying to figure it out. I've signed up
Fantastic! So happy our video helped you!!
Jesus...I was so confused until I found this. Not the exact thing I was after, but gave me an approximate idea on what I should be doing. Crystal clear explanation. Thank you so, so much.
I'm so glad it was helpful! Thank you so much for letting me know it helped you :-) Have a fantastic day. Sharyn
Thank you I think I did it right !! You explained it so perfectly that I could understand subscribed to your channel for sure
Awesome! Thank you!
The best explained vlookup on RUclips! Thank you so much 👍
Thank you! So glad you found it helpful 😊
Thanks. I've learnt some good tips from this video, which I've already started using at work. Nice name for the channel. I like the pun.
Awesome Cladius, thank you!
SO helpful! Spent hours trying to figure how to do this before I found this video and I was able to compare my two (very large) data sets in minutes!
Great to hear! Thank you for letting me know. Love it!
I have saved many hours by your help .Thanks alot .👍👍
Fantastic! So glad to hear that 😀
THANK YOU! I have struggled so much with this from other videos and gave up and decided to try again, this was SO easy to follow!! I was so excited when it worked for me! :)
Yay! So glad it helped! Thank you so much for letting me know Liisa 😊
You are amazing, this helped me so much after spending hours trying to figure out. I have subscribed 🙂
Awesome, thank you!
Perfect explanation and clarity . Thank you very much
You are so welcome!
Fantastic teacher !
Wow, thank you!
Been looking to solve my challenge for the last hour and have been driven mad by the long list of clowns giving advice. Being under the cosh, I needed a solution fast...! Solved by your brilliant video, thanks Sharyn! Looking forward to watching your other video's.
Fantastic! So glad I could help 😊
Very much detailed and informative video.Great Work.
Thank you so much for your kind comment Sadat. I'm so glad you found it helpful.
Thank you, thank you 😊 you saved a lot of time for me. You're amazing.
You're very welcome!
This as very helpful - Thank you
Thanks David! Yay! So great our video helped you. Thank you so much for letting us know 😊
You are the best!!! You just saved my life lol
Yayy! You are so welcome :-)
Thank you for great turtorial
Thank you. I'm so glad it was helpful!
Informative! Thank you!
You're welcome Jeffrey!
very helpful thanks
Glad it helped
FANTASTIC. !
Yayy! Glad you like it! Thanks Sheila 😊
Do you do any classes for beginner excel users? This was super helpful
Hi Kerry. Thank you and yes I do! I'm not sure where you are based but you can check out my courses here at excelatwork.co.nz 😀
Very knowledgeable
Thanks
Please advise me. I am trying to do a check on just the figure. The invoice between the 2 worksheet is exactly the same. Only the amount is different. Will Vlookup show #N/A on the amount if invoice number is exactly the same for both worksheet??
Hi Judy. As long as the VLOOKUP can find a match between the 2 worksheets it will return the figure. If you are trying to do a match based on the Invoice number AND the figure, you might like to check our my blog on how to do this excelatwork.co.nz/2021/08/22/vlookup-multiple-criteria-in-excel/
Hi, so it doesn’t have to be in ascending order? when you do vlookup.. thank you!
You are very welcome. Thanks for your message!😀
Question: I think me having duplicate values is what is causing my problems; however I need a way to return a value from sheet 1 based on a common item # in sheet 2. I do have multiple duplicate item #'s in sheet 2 and want to return a corresponding value from sheet 1 every time Excel find the numbers. What other function can I use if not VLOOKUP?
Hi there. I've replied to your email. Please let me know if you have any further questions 😀
Finally someone with a problem statement. Thanks a ton Sharyn. Please can I ask a few questions 1. We have now Index and Match and power query as well so why VLook Up 2. What are the other functions which are mostly useful with Vlook up ?again thank you. Are you from New Zealand ?
Such a great question! Index and Match and Power Query are fantastic tools. However sadly not many people actually know about them. 9 times out of 10 I'm asked to teach people how to use VLOOKUP, mainly due to legacy files that are full of VLOOKUP formulas AND so many employers are still asking specifically for VLOOKUP skills when hiring. So I can't see VLOOKUP going away any time soon. Although I'm trying really hard to show as many people as I can the new XLOOKUP function (video coming soon) which is AMAZING! And yes! I'm from New Zealand. Kia ora my friend!! 😀
Sorry, I didn’t answer your 2nd question. There are just so many. Definitely the TRIM function (video on this due out next week), the LEFT, RIGHT and MID functions and definitely the VALUE function. All fantastic functions to have in your toolbox to ensure your lookup functions work 👍
@@ExcelatWork Kia Ora legend
@@ExcelatWork True. .all used in Data remediation. Thanks a ton Legend ..look forward to see your videos & journey of knowledge with you ..
thanks
You're welcome!
I only have columns that have duplicates to work with, VLOOKUP is not working, what else can I use? 500 names in one, 141 in the other, I need to math which are in both. Thanks
Hi Jo. You might like to give Conditional Formatting a go. Check out this blog trumpexcel.com/compare-two-columns/ The steps under the heading 'Example: Compare Two Columns and Highlight Matching Data' may be what you need. I hope it helps.
Excelente video e informações. Obrigado
Muito obrigado. Estou feliz por ter ajudado você. Eu usei o Google translate, então espero que você possa entender meu comentário :-)
@@ExcelatWork Eu estou muito feliz por sua resposta. Estar em contato com você é motivo de grande felicidade. Muito obrigado e parabéns por seu excelente vídeo. Você é maravilhosa. Um grande abraço. Que Deus lhe abençoe, sempre.
I've followed your method accordingly. However, it did not show #N/A in my worksheet? Why is this happening?
Hi Judy. It could be that the Error Checking option has been turned off. Please check this blog out excelribbon.tips.net/T010655_Turning_Off_Error_Checking.html I hope it helps.
T H A N K Y O U .. you saved my day...
You are so welcome! I'm so glad it helped you 😀
Need to redo this using XLOOKUP - don't need to move columns around and it's not going to break if someone inserts a column later
You're right Andrew. I need to do an additional video on XLOOKUP. Amazingly I'm still training people who don't yet have the XLOOKUP function so this video still has a few more miles left in her 😊
I have to compare two files at work, the vendor file has over 6,000 entries of item number, cost, regular price, sale price, description, etc. The items we carry at our store is only close to 700 items. I have to compare these two files and update any changes into our accounting system (lightspeed). I can export the files we carry from lightspeed into an excel file. and can download the vendor file into excel. So it sounds like I need to put both files into a work book, and try doing a vlookup based on the common factor of the item number. Seems I will need to sort each sheet by item number, lowest to highest to start. then start the comparison. Can you give me a direction from here how to complete the vlookup? Or is the the best method to do the comparisons? I have noticed other videos using IF formulas, and seems a bit confusing, since I don't know anything about these formulas either. I appreciate any direction you may have . Judy
Hi Judy. Apologies for the slow reply. Sounds like you are on track. You don't need to sort the files if you are using VLOOKUP with a 'false' argument at the end of the function. If you follow this video and use the common factor of the item number for the lookup_value you should have success, e.g. the item number would replace the Invoice number example I use in the video. From what you have described to me I would recommend VLOOKUP instead of using IF functions. 😀
@@ExcelatWork thank you very for your reply. Will try it!
I followed every step and I'm still getting an error...
Though I appreciate your effort, not being able to explain 'absolute' with the F4 key or Fn+F4 on a Mac, you're kind of leaving out the point. This should be commented on vs... just saying to 'add in a $' with barely an explanation.