Compare Two Lists Using the VLOOKUP Formula

Compare two lists using the VLOOKUP formula in Excel. Use the VLOOKUP function to check two lists for missing items.

In this video, the VLOOKUP function is used with the ISNA function and IF to return a value if an item was in one list, but not the other.

We then look at using VLOOKUP with Conditional Formatting to highlight the row of the missing item in a different colour. The list can then be filtered to explore the list differences.

*** Online Excel Courses ***

Visit Computergaga For Lots More Tips

Connect with us!

[krystinbandy]

You have made my life SO much easier at work! Thank you so much for this amazing video!!!

[kawejoseph]

wow, this was so so so helpful to me. I comparing lists of items in excel containing over 2000 items and this video came in handy. I was so relieved. In less than 3 minutes I was done with over 2000 plus items, just like that. thank you mate.

[fernandarosenberg]

Your explanation is really efficient, and the way that you speak is really clear! Thanks for video, it makes the excel work easy and practical.

[drivingwanderlust]

Thanks SO much for this video! You saved me about 5 hours of time with this easy-to-follow instruction. I'd started combing through 2500 records just to find 800 missing from another file. I'd already spent roughly 2.5 hours going through 300 or so and figured there had to be a better way. I've never been great at Excel formulas even with instruction but this was simple and did exactly what I needed. I also looked like a superstar to my team, which wound up making me the lead on the project (yay?).

[samanthad]

I am doing my last project for excel unit in CIT, and I’ve been stuck on the same problem for over three hours now trying to figure this out and you are a GOD SEND!!!! Amazing teacher. Thank

[balajikumar]

You are great teacher!!
Love from India❤️❤️

[alvelasquez]

I have looked up a lot of Vlookup help tutorials and this video was a total winner. You explained it step by step. This helped me solve a huge issue with finding missed records.

[basheerahmed]

Dude! You nailed it! So far the best step-by-step guide I have seen. Thanks a ton!

[suethorpe]

Thank you so much. i have watched and read i don’t know how many so called explanations for comparing two lists of information with no success except yours.

[danielledinse]

Pretty sweet little tutorial. Well spoken, clear, accurate language, lots of techniques, logical. Thanks.

[rubenvargas]

I just used this to compare to large sets of data. You saved me so much time. This was fantastic. Thank you so much for sharing your knowledge.

Video was straight to the point. A million thank yous.

[erinadinu]

That IF(ISNA) formula is awesome. Thanks for that!

[sanhanessian]

Thank you so much for this video!!! After struggling with these formulas, you were the only one I could understand. You're THE BEST 🤩

[gloriaruiz]

OMG, everyone needs this to compare list. I have been trying before until I saw your video. Thank you, THIS IS A LIFE SAVER

[egarcia]

This was SO helpful!!! I couldn't exit out of the video, without telling you how much this saved my life. Thank

[StarZaan]

First time using VLookup and after your clear instruction -got it immediately! Thank you!

[w-z]

Wow thanks this video is great, had to learn v lookup today in work, my mind was boggles but this has explained it perfectly and with good humour and the human touch, many thanks

[BeenHereYet]

Best tutorial EVER! Thank you so very much for this share
I have never done this and you made it so clear. and effortless. Saved me hours.

[stephaniebeard]

Thank you so much. You've just saved me so much time as I have more than 500, 000 records to review over 38 reports. This is the the first time that the explanation actually made sense and worked for me!

[MissT]

It’s been about two years since I used VLookup, and I was rusty. You brought it all back to mind. Thank you