Compare Two Lists Using the VLOOKUP Formula

[@krystinbandy9577]

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

[@Computergaga]

You're very welcome. Thank you Krystin.

[@sujithsuji274]

Video is not clarity sir... Please upload clarity video

[@srilekhaj3915]

Hi can u tell me how to match the same columns with two excels...

[@nycollassilva3558]

Bn1fcj,

[@PriyaSingh-ee5ck]

Akka valla intiki vellindhi akka akkadiki thisukuni vellanu

[@kawejoseph2382]

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.

[@drivingwanderlust4202]

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?).

[@Computergaga]

Excellent work Sharise.

[@alvelasquez7157]

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.

[@Computergaga]

Glad it helped! Thank you 😀

[@fernandarosenberg2848]

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.

[@Computergaga]

Thank you very much Fernanda. I'm happy to help.

[@danielledinse6657]

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

[@Computergaga]

Thanks Danielle.

[@egarcia0522]

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

[@Computergaga]

You're welcome! Thank you for leaving the comment.

[@gloriaruiz13]

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

[@Computergaga]

You're so welcome, Gloria. Thank you for your comments.

[@samanthad708]

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

[@Computergaga]

You're very welcome, Samantha. Thank you 😊

[@basheerahmed9095]

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

[@Computergaga]

You're welcome Basheer. Thank you.

[@316julius]

Thank you for making excel life much easier. Best tutorial on KZbin.

[@Computergaga]

You're very welcome. Thank you 😊

[@suethorpe6952]

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.

[@Computergaga]

You're welcome Sue. Glad to hear that it helped.

[@qatestbrian1]

Sue, you said it. So many poor explanations and then there is Mr. Gaga. Perfect and thanks.

[@rubenvargas4233]

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.

[@Computergaga]

You're very welcome, Ruben. Thank you. I'm so glad that it helped.

[@roxylovingly]

OMG I'm so mad at myself for not coming accross your video years ago...hours of my life were just saved

[@Computergaga]

😜 Nice work!

[@stephaniebeard6319]

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!

[@Computergaga]

Excellent! You're welcome.

[@segunplay]

You are a life saver bro. This video is ever-green....

[@Computergaga]

😊 Great!

[@pavankotharu]

Amazing Video. Clean and clear. Please keep posting more

[@Computergaga]

Thank you, I will 😊

[@MissT813]

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

[@Computergaga]

You're very welcome!

[@StarZaan]

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

[@Computergaga]

Brilliant to hear, Riri 👍

[@erinadinu8585]

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

[@Computergaga]

It sure is. My pleasure Irina.

[@w-z198]

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

[@Computergaga]

My pleasure. Thank you for your comment.

[@balajikumar10]

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

[@Computergaga]

Thank you very much, Balaji 😊

[@qatestbrian1]

Computergaga, you are a terrific teacher. I could do exactly this task after watching your video. Sue Thorpe says it perfectly below.

[@Computergaga]

Thank you very much Adrian.

[@sarahwhite7052]

This is the BEST vLookup example/explanation I've ever seen! Thank you!

[@Computergaga]

Thank you very much Sarah 😊

[@akhilsadanandan2139]

Thank you boss. This vedio is very useful for me.. Your presentation style is different. Easy to understanding the concepts.

[@Computergaga]

That is great to hear. Thank you, Akhil.

[@russellcolumbo5426]

A very clear explanation of the the vlookup feature. Thank you!!!!

[@Computergaga]

Thank you Russell 😊

[@ratulahmed2823]

Thank you Sir. You save my day, otherwise i had to lookup for 1000s of duplicate entries on the other sheet.

[@Computergaga]

Great to hear. Happy to help Ratul.

[@amanuelamente6214]

@@Computergaga Thanks. I could have stayed late than I'm already is haven't I seen your content.

[@mdtaylor2274]

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.

[@Computergaga]

You're welcome Michael. Best of luck for the interview.

[@mdtaylor2274]

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. 👍🏼

[@Computergaga]

Thank you Michael. We are connected on LinkedIn :)

[@laptopdigitalli7387]

Excellent tutorial. Computergaga you rock. Welldone.

[@Computergaga]

Thank you very much.

[@richardgordon]

Thank you! Your work lives on. By far the clearest and easiest explanation to follow without all the unnecessary bs!

[@Computergaga]

Thank you, Richard.

[@YanBrassard]

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.

[@Computergaga]

Very happy to help Yan. I have multiple videos on VLOOKUP that you can check out. And yes it is extremely popular in businesses.

[@sanhanessian6984]

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

[@Computergaga]

Thank you very much 😊 Really glad it helped.

[@GS-uc9yl]

This is the most helpful tutorial that I have found. Thank you!

[@Computergaga]

That is great. Thank you. I'm glad it was helpful.

[@lindamatrone6827]

Awesome Vlookup video, super clear and very useful

[@Computergaga]

Thank you Linda.

[@wan12345]

Alhamdulillah, thanks a lot bro.. shared a new knowledge of Excel to me. solved my works. greet from Malaysia...

[@Computergaga]

My pleasure. Great to hear that it helped.

[@TheGroovisthecat]

Hi there, very helpful. Do you know how I can match two rows that have values in differing orders, and then match them?

[@staticplayz7377]

AWESOME! I'VE BEEN TRYING WHOLE DAY! AND ONLY YOUR TUTORIAL MADE IT EASY! LALALALLALALA THANKS MATE!

[@Computergaga]

You're welcome! 👍

[@ann8795]

Yoiu saved me!!!! I have 6 sheets to compare and you made it so easy. My boss will love me now

[@Computergaga]

That's fantastic. My pleasure Ann.

[@edenteuira-hussein8121]

Thanks for the tutorial, I spent all night trying to figure out this formula. Amazing !

[@Computergaga]

You're very welcome 👍

[@randoriryan]

"What have I done?" LOL. I literally say this the entire time I'm trying to build a formula.

[@Computergaga]

😂

[@anishmalik6474]

Couldn't be a better explanation, this is the best tutorial for VLookup. I liked the Brit accent. Oh My Gosh.

[@Computergaga]

Thanks Anish.

[@dunlapg75]

Great tutorial! Saved me hours of manual comparison work. Thanks!

[@Computergaga]

Happy to help.

[@punjabiG]

Just what I needed when I needed it. Thank you!!

[@Computergaga]

Awesome!!

[@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.

[@Computergaga]

Excellent to hear. Thank you Lance.

[@jonchapman621]

Thanks for sharing!!! I watch yours and Vanna Excel for my marketing work on VLOOKUP!

[@Computergaga]

My pleasure. That is great to hear Jon.

[@marutiprasad6310]

You made my day. Thanks this was the most helpful V LOOKUP tutorial

[@Computergaga]

Great to hear. Thank you Maruti.

[@navinhurree7301]

Many thanks. Solved my puzzle in minutes. Keep the good work!

[@Computergaga]

You're welcome. Good to hear. Thanks Navin 👍

[@genevevev.valenzuela4398]

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

[@Computergaga]

Thank you, Monalissa. That is great to hear.

[@Andy766702]

Thank you soooo much. I keep referring to the internet everytime I need this function, your is the best explanation that will help loads

[@Computergaga]

That is great to hear. Thank you, Andy.

[@irasemalahoz5053]

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

[@Computergaga]

You're very welcome! Thank you, Irasema.

[@lisahorton6824]

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 :(

[@Computergaga]

Hi Lisa, what you got?

[@traviskent3108]

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.

[@thabonape5247]

You're a superhero for this one. Thank you

[@Computergaga]

You're welcome. Thanks.

[@hankgrimes1806]

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!

[@Computergaga]

Thank you Hank. You're welcome.

[@avelyndelacruz582]

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

[@Computergaga]

You're welcome! Thank you for your comments.

[@shenitamarr4517]

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.

[@Computergaga]

Thank you very much Shenita.

[@aarongodwin1000]

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!

[@Computergaga]

Great to hear.

[@SIMRANKAUR-eg7nc]

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. kzbin.info/www/bejne/a5fWnqxpqtyimZo

[@cathyb2204]

Excellent video. I had the same problem with the quotation marks, so it was very helpful that you left that in.

[@Computergaga]

Happy to be of help Cathy.

[@mazabrady4337]

I had that same problem too! Ditto Cathy's appreciation

[@fostero922010]

This is the most helpful tutorial ever! Many thanks!

[@Computergaga]

My pleasure Chelsea.

[@jenniferrose7346]

Great instructions. Very easy to follow. Thank you!

[@Computergaga]

You're very welcome, Jennifer. Thank you.

[@world752]

Man, you deserve a million sub

[@Computergaga]

Thank you very much.

[@qaz9258]

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.

[@qaz9258]

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.

[@Computergaga]

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.

[@qaz9258]

@@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.

[@Computergaga]

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.

[@qaz9258]

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

[@josephfarrugia5829]

Thanks very much. In this tutorial I learned more than one tip. Very interesting.

[@Computergaga]

Great to hear. Thanks Joseph.

[@ExcelSquad]

Bro I'm a huge fan of excel. Your teaching methodology is really quite interesting

[@Computergaga]

Thanks Raju. Very nice to hear.

[@MargaretUK]

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 👍

[@Computergaga]

Thank you Margaret. Your comments are appreciated.

[@kingoflame2031]

Bloody Legend. Works out of all the videos in the net

[@Computergaga]

Excellent!!

[@sparshbhasin18]

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.

[@Computergaga]

No problem. Glad it is working out for you.

[@sureshvaghela1984]

Thank you so much. It's very helpful for me to work with very large amount of data to compare and short out.

[@Computergaga]

You're welcome, Suresh.

[@buddhikaperera5716]

thank you very much sir.. that is what i have been looking.. u explain it in very very easy way..

[@Computergaga]

That is great to hear, Buddhika. Thank you.

[@mks2443]

Excellent video..very helpful..Thank you for sharing

[@Computergaga]

Thank you. I'm glad it was helpful.

[@jaylakhani5568]

Thanks mate, saved me on a uni project for accounting

[@ivarification]

Thanks a lot .Precise tutorial for Vlookup .Love the way it is explained.

[@Computergaga]

Thank you, Ravi.

[@gerryskill5488]

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

[@andywithers592]

That was extremely helpful. Thankyou for the clear step by step instructions.

[@Computergaga]

You're welcome, Andy.

[@lessyara1129]

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.

[@Computergaga]

Thank you very much Amsy.

[@pradeepap9365]

My long term bothering doubt got cleared!! Thank you very much!

[@Computergaga]

Glad it helped! You're welcome, Pradeepa.

[@jorgeochoaleon]

Love your level of detail of excel the VLOOK formula for comparing two tables!!

[@Computergaga]

Thank you Jorge.

[@lucywere8794]

Finally!I was able to do this.Thank you so much.

[@Computergaga]

Great! No worries.

[@zhaozhang4047]

Thank you for the quality vid! I've learnt a great deal from you... I think another way to do conditional formatting in this case would be: 1) Apply IFERROR to the N/A customers and name them as whatever you want, for example, "NOT ON LIST" 2) Go to conditional formatting and highlight cells that contain "NOT ON LIST"

[@Computergaga]

Absolutely you can do this.

[@bashgalsport]

Thank you so much for the video!

[@Computergaga]

You're welcome.

[@TheVenueSearcher]

omg why am i only seeing this in 2021!!! *Crying* this was extremely useful, THANK YOU SO MUCH!

[@TheVenueSearcher]

THIS BY FAR THE BEST EXPLANATION EVER ON KZbin!

[@Computergaga]

You're very welcome. Thank you 😊

[@BereccaSmith]

This is an excellent explanation, thank you!

[@Computergaga]

You're welcome. Thank you Rebecca.

[@debrajohnson852]

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?

[@Computergaga]

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.

[@SIMRANKAUR-eg7nc]

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.

[@bigbadstig]

Yet another life saver, thank you. One thing however, you used the ID as the cells to look up, i need to look up both first and second names as my mist does not have IDs, any tips as i'm struggling a bit? Thank you again

[@Computergaga]

Glad to be of help. I have a video on doing a VLOOKUP on first and last name here - kzbin.info/www/bejne/kKK6haajoJd9oZo You can combine this technique with what is shown to compare lists.

[@bigbadstig]

And that Alan, is the reason I subscribe to this channel. Thank you again.

[@amofavirtuosomichael2586]

Fantastic video of all time.

[@Computergaga]

👍 😊

[@fierymusic1572]

really useful (and easy to understand) video. thank you!

[@Computergaga]

You're welcome.

[@sidharthjaiswal]

Very useful and clean simple way of comparing data. Bingo.

[@Computergaga]

Thank you Sidharth.

[@NarutoHarryPotter]

Thank you so much!!! Is there a way Not to have those “” appear at the end before doing the color part? Every time I make a rule, I have to go back and edit it again to remove those quotes, just as you did. Otherwise works fantastic!

[@GarethNIreland]

Worked for me - English competence at its best 👍🏻

[@Computergaga]

Excellent!

[@tun-tunninc.6492]

I'm so glad I subscribed. Thank you.

[@Computergaga]

Thank you.

[@bhupalan]

Perfect video and this is what I was searching for.

[@Computergaga]

Awesome! Thank you, Bhupalan.

[@bhupalan]

@@Computergaga I must thankyou... for the reply and this video... :)

[@rishabvempati4698]

Thanks for your explanation. It helped me.

[@Computergaga]

Great to hear Rishab. You're welcome.

[@shoepm]

Computergaga, I have a table that doesn't have unique values ie, no ID kind of column. It has repeatable rows. How to do then ?

[@TheAkliukai]

Watched quite few excel tutorial videos, but I'm finding this one the best! Well explained ;) Thank you

[@Computergaga]

Thank you very much Arnie.

[@eduarmon2128]

Boy did I need this. Thank you

[@Computergaga]

My pleasure.

[@andreal5947]

Only thing that worked for me. Thanks a million.

[@Computergaga]

You're very welcome

[@mindytu3895]

Best video about how to use vlookup! Thank you so much! Please upload more! I am going to watch the rest of videos. :)

[@Computergaga]

Thank you Mindy.

[@Helena-kq7tr]

This just saved my life. Thank you!!!

[@Computergaga]

You're very welcome, Helena.

[@TitChheang]

Wow, Thank you so much dear, your content is so helpful 😘😘

[@Computergaga]

You're so welcome!

[@pfanomukhodobwane1666]

Thank you so much for this video, it really assisted me in my work project.

[@Computergaga]

Great to hear, Pfano. You're welcome.