HOW TO: compare two columns in Excel using VLOOKUP

If you want to save yourself a huge amount of time when reconciling data, learn how to use VLOOKUP to compare two lists or columns of data.

I’ll also share with you the key things you need to avoid to ensure your VLOOKUP works correctly.

❤ VERSION FRIENDLY ❤
Try this with Excel 2010, Excel 2013, Excel 2016, Excel 2019 and Excel for Office 365.
Sharyn’s using the desktop version of Excel for Office 365 as part of the Office 365 Business Premium subscription.

#ExcelTutorial #ExcelTips #ExcelBeginner #ExcelIntermediate #ExcelatWork #ExcelVLOOKUP

[ExcelatWork]

Let Sharyn help you learn how to use VLOOKUP to compare two lists or columns of data (download the exercise file to follow along).

[mrssclarkie]

I think you were the first person that explained this in a way that makes sense 👌🏽

[s_nday]

I hope you know you just helped me 3 years later! Thank youuuu

[chrisstyles]

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

[martyjohnstone]

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!!

[liisalilley]

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! :)

[rosalinl]

Finally found a tutorial that easy to understand. Big thanks!

[_ctpaxop]

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.

[charlottepine]

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!

[cladiusfern]

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.

[jacquelinechallenger]

The best explained vlookup on YouTube! Thank you so much 👍

[suhasr]

You are fantastic. This was extremely helpful after spending hours trying to figure it out. I've signed up

[simona]

Thank you, thank you 😊 you saved a lot of time for me. You're amazing.

[tawandacosby]

Thank you I think I did it right !! You explained it so perfectly that I could understand subscribed to your channel for sure

[TomSafariDust]

You are amazing, this helped me so much after spending hours trying to figure out. I have subscribed 🙂

[UsmanKhan-kggq]

I have saved many hours by your help .Thanks alot .👍👍

[MrMaggypie]

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.

[sadatanik]

Very much detailed and informative video.Great Work.

[manasitelang]

Perfect explanation and clarity . Thank you very much

[Tatyana-gzqv]

You are the best!!! You just saved my life lol