Compare Two Lists Using the VLOOKUP Formula
Вставка
- Опубліковано 13 жов 2024
- Compare two lists using the VLOOKUP formula in Excel. Use the VLOOKUP function to check two lists for missing items.
Learn it all with the Ultimate Excel course - bit.ly/Ultimat...
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 **
The Ultimate Excel Course - Learn Everything ► bit.ly/Ultimat...
Excel VBA for Beginners ► bit.ly/37XSKfZ
Advanced Excel Tricks ► bit.ly/3CGCm3M
Excel Formulas Made Easy ► bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► bit.ly/2Siivkm
Visit Computergaga For Lots More Tips
www.computerga...
Connect with us!
LinkedIn ► / 18737946
Instagram ► / computergaga1
Twitter ► / computergaga1
You have made my life SO much easier at work! Thank you so much for this amazing video!!!
You're very welcome. Thank you Krystin.
Video is not clarity sir... Please upload clarity video
Hi can u tell me how to match the same columns with two excels...
Bn1fcj,
Akka valla intiki vellindhi akka akkadiki thisukuni vellanu
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.
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.
Thank you very much Fernanda. I'm happy to help.
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?).
Excellent work Sharise.
Dude! You nailed it! So far the best step-by-step guide I have seen. Thanks a ton!
You're welcome Basheer. Thank you.
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.
You're welcome Sue. Glad to hear that it helped.
Sue, you said it. So many poor explanations and then there is Mr. Gaga. Perfect and thanks.
Pretty sweet little tutorial. Well spoken, clear, accurate language, lots of techniques, logical. Thanks.
Thanks Danielle.
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.
Glad it helped! Thank you 😀
That IF(ISNA) formula is awesome. Thanks for that!
It sure is. My pleasure Irina.
"What have I done?" LOL. I literally say this the entire time I'm trying to build a formula.
😂
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 you!!!!!!
You're very welcome, Samantha. Thank you 😊
Thank you so much for this video!!! After struggling with these formulas, you were the only one I could understand. You're THE BEST 🤩
Thank you very much 😊 Really glad it helped.
OMG, everyone needs this to compare list. I have been trying before until I saw your video. Thank you, THIS IS A LIFE SAVER
You're so welcome, Gloria. Thank you for your comments.
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.
You're very welcome, Ruben. Thank you. I'm so glad that it helped.
Thanks so much for this! I have been struggling with a comparison for over an hour. I watched 2 other videos and it still didn't work. Yours DID! Thank you!
Great to hear.
Awesome video. Almost covered every situation. I come across different situations so I keep searching good vidoes. For others help I recommend watching this video. Complete package.
ua-cam.com/video/5fsmy3uwoc8/v-deo.html
This was SO helpful!!! I couldn't exit out of the video, without telling you how much this saved my life. Thank you!!!!!!
You're welcome! Thank you for leaving the comment.
Thank you Sir. You save my day, otherwise i had to lookup for 1000s of duplicate entries on the other sheet.
Great to hear. Happy to help Ratul.
@@Computergaga Thanks. I could have stayed late than I'm already is haven't I seen your content.
Amazing Video. Clean and clear. Please keep posting more
Thank you, I will 😊
You made my day. Thanks this was the most helpful V LOOKUP tutorial
Great to hear. Thank you Maruti.
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.
Excellent to hear. Thank you Lance.
Thank you! Your work lives on. By far the clearest and easiest explanation to follow without all the unnecessary bs!
Thank you, Richard.
Excellent video. I had the same problem with the quotation marks, so it was very helpful that you left that in.
Happy to be of help Cathy.
I had that same problem too! Ditto Cathy's appreciation
Thank you for making excel life much easier. Best tutorial on UA-cam.
You're very welcome. Thank you 😊
That was great, thank you. I like that you left in the error that was made with the formula, it's the best way to learn 👍
Thank you Margaret. Your comments are appreciated.
A very clear explanation of the the vlookup feature. Thank you!!!!
Thank you Russell 😊
You are great teacher!!
Love from India❤️❤️
Thank you very much, Balaji 😊
Thank you boss. This vedio is very useful for me.. Your presentation style is different. Easy to understanding the concepts.
That is great to hear. Thank you, Akhil.
This is the BEST vLookup example/explanation I've ever seen! Thank you!
Thank you very much Sarah 😊
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
My pleasure. Thank you for your comment.
It’s been about two years since I used VLookup, and I was rusty. You brought it all back to mind. Thank you
You're very welcome!
First time using VLookup and after your clear instruction -got it immediately! Thank you!
Brilliant to hear, Riri 👍
Thanks for sharing!!! I watch yours and Vanna Excel for my marketing work on VLOOKUP!
My pleasure. That is great to hear Jon.
This is the most helpful tutorial that I have found. Thank you!
That is great. Thank you. I'm glad it was helpful.
Out of the many video tutorials i've watched, this one by far was the best! I totally understood your instructions and was able to follow! The only snag I ran across was that the cell in the first spreadsheet had to be formatted properly.
Thank you very much Shenita.
Many thanks. Solved my puzzle in minutes. Keep the good work!
You're welcome. Good to hear. Thanks Navin 👍
Excellent tutorial. Computergaga you rock. Welldone.
Thank you very much.
I was so encouraged when I watched your video and how you explained each step clearly and didn't go too fast with your instruction. Unfortunately, my formula hasn't worked and I can figure out why :(
Hi Lisa, what you got?
Thanks for the tutorial, I spent all night trying to figure out this formula. Amazing !
You're very welcome 👍
wow!!!! thank you so much!!! been scared to even try to learn how to do this but just by watching and actually trying to apply the formula here, I realized it's something fun to do. keep up the good work!!!
Thank you, Monalissa. That is great to hear.
I have a interview tomorrow and I'll need to pass an Excel exam for vlookups. This is fantastic for clearing out my cobwebs. Thank you very much.
You're welcome Michael. Best of luck for the interview.
Computergaga thanks mate. I've just visited your website and will definitely pick up a few courses. Also sent you a LinkedIn invite. You're a brilliant trainer. 👍🏼
Thank you Michael. We are connected on LinkedIn :)
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!
Excellent! You're welcome.
This is the most helpful tutorial ever! Many thanks!
My pleasure Chelsea.
Great instructions. Very easy to follow. Thank you!
You're very welcome, Jennifer. Thank you.
Thank you very much , you were very detailed and make it easy for the ones who are not an expert in excel like me :) thank you so much !!!
You're very welcome! Thank you, Irasema.
Thanks very much. In this tutorial I learned more than one tip. Very interesting.
Great to hear. Thanks Joseph.
That was extremely helpful. Thankyou for the clear step by step instructions.
You're welcome, Andy.
Thank you soooo much. I keep referring to the internet everytime I need this function, your is the best explanation that will help loads
That is great to hear. Thank you, Andy.
Thank you so much for this video…I know it’s been around, but this just helped me figure out why two reports that should have been identical had a 153 row discrepancy. We are in the middle of purging data from the company we divested from and running data validation testing to ensure data integrity once we go live, and this was a major report with all of our sales order history.
Great tutorial! Saved me hours of manual comparison work. Thanks!
Happy to help.
Just what I needed when I needed it. Thank you!!
Awesome!!
Love your level of detail of excel the VLOOK formula for comparing two tables!!
Thank you Jorge.
Awesome Vlookup video, super clear and very useful
Thank you Linda.
OMG I'm so mad at myself for not coming accross your video years ago...hours of my life were just saved
😜 Nice work!
Amazing!! Thank you so much for your guidance and way of explaining this function!
Your welcome Aaron, thank you.
Computergaga, you are a terrific teacher. I could do exactly this task after watching your video. Sue Thorpe says it perfectly below.
Thank you very much Adrian.
These tutorials will be so damn useful. I applied to another position at work that requires to know some basics about Excel formulas. I spoke with a few people holding this position to have an insight about the interview process, they all told me : practice the Vlookup formula, we're using it quite often. If you can master it before the interview, they will be positively surprised. Thanks a lot, I'll keep this video in my favorites.
Very happy to help Yan. I have multiple videos on VLOOKUP that you can check out. And yes it is extremely popular in businesses.
Thank you! My first time running a VLookup and you made it so simple! : )
Excellent! So happy to hear that Maureen.
You are a life saver bro. This video is ever-green....
😊 Great!
Alhamdulillah, thanks a lot bro.. shared a new knowledge of Excel to me. solved my works. greet from Malaysia...
My pleasure. Great to hear that it helped.
Thanks a lot .Precise tutorial for Vlookup .Love the way it is explained.
Thank you, Ravi.
I can't thank you enough for sharing this video! I found it right when I needed it. As a language program administrator, I often have to keep up with attendance, grades, and changing enrollment, and this technique saved me tons and tons of time. You are the MAN!
Thank you Hank. You're welcome.
really useful (and easy to understand) video. thank you!
You're welcome.
thank you very much sir.. that is what i have been looking.. u explain it in very very easy way..
That is great to hear, Buddhika. Thank you.
Hi there, very helpful. Do you know how I can match two rows that have values in differing orders, and then match them?
Watched quite few excel tutorial videos, but I'm finding this one the best! Well explained ;) Thank you
Thank you very much Arnie.
omg why am i only seeing this in 2021!!! *Crying* this was extremely useful, THANK YOU SO MUCH!
THIS BY FAR THE BEST EXPLANATION EVER ON UA-cam!
You're very welcome. Thank you 😊
Thank you so much. It's very helpful for me to work with very large amount of data to compare and short out.
You're welcome, Suresh.
You are the best! Your videos have really helped me. Thank you very much!
You are very welcome. Thank you.
This really helped me out
Thanks for sharing the priceless one.
Great to hear. You're very welcome.
Really very useful - well presented. I actually understood it all!
Thank you so so much! Got it in first time, that hardly happens with me. I can't tell how much I needed this. I have been losing so much in online sales because of this feature. Thanks to you no more cancellations on Amazon from now on. Again Thanks so much.
No problem. Glad it is working out for you.
Bro I'm a huge fan of excel. Your teaching methodology is really quite interesting
Thanks Raju. Very nice to hear.
Very useful and clean simple way of comparing data. Bingo.
Thank you Sidharth.
My long term bothering doubt got cleared!! Thank you very much!
Glad it helped! You're welcome, Pradeepa.
Finally!I was able to do this.Thank you so much.
Great! No worries.
AWESOME! I'VE BEEN TRYING WHOLE DAY! AND ONLY YOUR TUTORIAL MADE IT EASY! LALALALLALALA THANKS MATE!
You're welcome! 👍
This is very detailed and exactly what I was looking for, thanks!
You're welcome Craig. Thank you.
EXACTLY what I was searching for. And excellent clarity in your instruction.
I have a yearly work calendar that I keep my daily scheduled hours on. All the dates are in a single row and I need to know what days I am off to preschedule my month. I was taking the dates once given and coloring the cell red. BUT each year that is a pain to undo and reset for next year. Now I have all the holidays and extra time off in a separate table that is auto calculated by the year number. Using your totorial the calendar now auto updates in a flash.
PS my conditional formatting is cashing with an other conditional formatting and some days are not highlighting at that cell. This day off should trump the other. The one that dominates is for the entire table. The one that gets vetoed is for a column.
If you click Conditional Formatting > Manage Rules. Ensure the one you want to be more dominant is higher in the list. Use the arrow buttons to move the rules.
@@Computergaga Thank you for your swift reply.
I only see the option to set priority withing the condition that applies to the same sell range. But of the Window that houses the list conditional rules (Manage Conditional Formats) is listed in cell reference alphabetical order. I see no option to change this order.
In this table I have the 1st and 15th conditioned to draw a line vertically across the table helping me see the separation between months. The other format will highlight Holidays. However for example. Jan 1st is an intersection of conflict between the 1st and a holiday. I see the line but the highlight for the holiday does not post.
This also happens at spring break week.
There is a drop down list at the top to change between selected cells or entire sheet. And also two arrows to move rules up and down. Nex to the delete rule button.
Alternatively, you can write rules to apply formatting except another scenario. Then the order does not matter, but this is more difficult.
Thank you solved. I am using Libre Office. Appears the conditions referencing the cell from different array parameters are grouped separately and can't be rearange on the level needed. This detaed feature I will request to implement. Had to delete the the dominant condition and add back. That fixed it
Thank you so much, this is very helpful and exactly what I was looking for.
Excellent video..very helpful..Thank you for sharing
Thank you. I'm glad it was helpful.
This is an excellent explanation, thank you!
You're welcome. Thank you Rebecca.
This was so much fun to watch. As a person who uses excel on a daily, thank you very much 🙏
Thanks, Reuben.
Thank you so much for this. Helped a lot!
Great! You're welcome, Kinyanjui.
THANK YOU SO MUCH! VERY EASY TO FOLLOW! I JUST TOLD MY MANAGER I KNOW HOW TO USE THIS WHEN I DON'T HAVE ANY IDEA HOW TO DO SO! LOOOOL!!
You're welcome! Thank you for your comments.
This is a lifesaver, thank you for a clear and logical explanation
My pleasure. Thank you Paul.
Best video about how to use vlookup! Thank you so much! Please upload more! I am going to watch the rest of videos. :)
Thank you Mindy.
Thanks a Lot Sir, I learned a new priceless maneuver from yours above video. Thanks Again.
Thank you Rohit. Glad to help.
This is exactly what I needed! Thank you so much!!
You're so welcome, Alicia.
Thank you so much for this video, it really assisted me in my work project.
Great to hear, Pfano. You're welcome.
U really did make it very simple and precise . Thanks 😊
My pleasure 😊
Thank you so much!
Thanks a lot!!!
Exactly what I needed.
You're very welcome, Cesar.
Thank you so much for the video!
You're welcome.
Thanks for your explanation. It helped me.
Great to hear Rishab. You're welcome.
Thanks so much for this video. I watched several others & still had issues; now it's clear!
Excellent! You're very welcome Marta.
Yoiu saved me!!!! I have 6 sheets to compare and you made it so easy. My boss will love me now
That's fantastic. My pleasure Ann.
Love your tutorials... I am struggling with this VLOOKUP formula and applying it to my two sheets for compare.... do you have a suggestion on where I could go for an answer?
Thank you. the most common mistake is that the first row for the area you highlight and the area VLOOKUP matches need to be the same i.e. don't select the entire column.
The problems faced by u used to be that of mine. Along with this code u can also try one more vidoe on chanel "off to office". You will really thank me.
I’m teaching myself basic excel and just watched your other vid about vlookups. And totally got it, thanks! But I’m getting it wrong when I’m trying to copy the table array from another tab. It’s highlighting the first tab. Hopefully one of your vids will tell me why!!
VERY helpful … wonderful pace -- easy to follow!
Excellent!! Thank you Robin.
Boy did I need this. Thank you
My pleasure.
Thank you so much for your tutorial. I've watched several tutorials on VlookUp but yours is the easiest way to understand. I love it so much. It's not complicated. And because of that, I subscribed to your channel.
Thank you very much Amsy.