VLOOKUP Excel Tutorial for HR Professionals (How to use VLOOKUP)

[@smeckert34]

Thank you so much for creating this. This is going to help me so much!

[@SharonSmith]

You're very welcome! I'm so glad you found it helpful! I have two other videos you might like on VLOOKUP and also XLOOKUP: kzbin.info/www/bejne/lWOrgHeabaykaaM (this one is how to match names on two sheets using VLOOKUP) and kzbin.info/www/bejne/iIG8k5mInL6ZrM0 (pulling data with VLOOKUP and XLOOKUP). I hope this helps!

[@francesdobbins2964]

I really enjoyed your Vlookup video, it was extremely helpful. Please create more Vlookup tutorials.

[@SharonSmith]

I'm so glad you liked this video! I plan on doing another VLOOKUP tutorial on not just how to, but also how to troubleshoot and fix errors. If you haven't already subscribed, be sure to subscribe and click the bell to receive notifications when I post new videos. Thank you for watching!

[@farizi1302]

thank you so much for the video! the explanation was clear even for a total beginner like me

[@SharonSmith]

Hi Farizi, you are very welcome. I'm so glad you found this video helpful. VLOOKUP is not too hard once you try it and use it a few times. Hope you have a chance to watch some of my other videos and become more confident in your technical skills! Thanks so much for watching and taking time to leave a comment, I appreciate it. Take care!

[@PowerRangerIND]

Simple and clear explanation then my teacher,thank you madam ☺️🇮🇳

[@SharonSmith]

Very glad to help! Thanks so much for watching my videos and subscribing to my channel!

[@jamieallen981]

Great video! Thanks!

[@cmrnb8846]

Thanks for knowledgeable tutorial

[@SharonSmith]

You are very welcome and glad you found this video helpful! Thanks for watching and taking time to leave a comment. I really appreciate it!

[@usmanrajput6885]

Really helpful. Thanks.

[@SharonSmith]

Thank you so much! I'm glad you found this video helpful. Thanks for watching a leaving a comment!

[@victorious9491]

Thank you, this was very useful 👌🏽

[@SharonSmith]

You are very welcome! Glad you found my videos helpful. Thanks for watching!

[@almaroberts3092]

I would like to see more HR VLookup

[@SharonSmith]

Hi Alma! Here is a recent video I published that has another VLOOKUP tutorial using a real-life example. I hope this helps: kzbin.info/www/bejne/lWOrgHeabaykaaM Thanks for watching!

[@somewhereupthere]

😍 amazing

[@Akolkar2]

Pl make one sheet and describe steps to use vlookup syntax bcoZ here in this video complex to understand.

[@rubenflores5284]

Thank you for the amazing video Sharon! Im not an HR professional but I am seeking this career path. Quick question. Is column A automatically the same as B when you receive the spreadsheet? Or do you have to input those ID numbers yourself? Thank you!

[@SharonSmith]

Hi Ruben! That is great, I wish you the best in pursuing an HR career path. In this video, the two reports I use are examples of an employee database so the employee ID numbers tie to the same employees on each spreadsheet. On the main sheet, we are missing the Manager column, but we have it on the second spreadsheet, so using the employee ID number, we can pull the manager name over into the main spreadsheet. Excel is using that ID number to match the correct manager name. Hope that makes sense. Thanks so much for watching my videos!

[@vijaymuthukuru9647]

Hi ma'am I need your Excel spreadsheet for practice...can u share this for practice purpose.plz help on this

[@somewhereupthere]

My favorite video 😏

[@SharonSmith]

Lol! Thanks for watching them all!

[@sophanasorn6218]

Love you 💕

[@SharonSmith]

Thanks for watching!

[@usmaniqbal1836]

Please share link this file for download

[@gauribijwe1041]

Please send me some more examples

[@gabrielokpe6664]

Vlookup

[@fatimaibrahimadaminda8928]

Vllookup