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

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

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

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

[@balajikumar10]

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

[@Computergaga]

Thank you very much, Balaji 😊

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

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

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

[@danielledinse6657]

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

[@Computergaga]

Thanks Danielle.

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

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

[@erinadinu8585]

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

[@Computergaga]

It sure is. My pleasure Irina.

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

[@316julius]

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

[@Computergaga]

You're very welcome. Thank you 😊

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

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

[@StarZaan]

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

[@Computergaga]

Brilliant to hear, Riri 👍

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

[@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 :)

[@randoriryan]

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

[@Computergaga]

😂

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

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

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

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

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

[@segunplay]

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

[@Computergaga]

😊 Great!

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

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

[@sarahwhite7052]

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

[@Computergaga]

Thank you very much Sarah 😊

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

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

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

[@bashgalsport]

Thank you so much for the video!

[@Computergaga]

You're welcome.

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

[@fostero922010]

This is the most helpful tutorial ever! Many thanks!

[@Computergaga]

My pleasure Chelsea.

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

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

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

[@marutiprasad6310]

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

[@Computergaga]

Great to hear. Thank you Maruti.

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

[@laptopdigitalli7387]

Excellent tutorial. Computergaga you rock. Welldone.

[@Computergaga]

Thank you very much.

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

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

[@edenteuira-hussein8121]

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

[@Computergaga]

You're very welcome 👍

[@ExcelSquad]

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

[@Computergaga]

Thanks Raju. Very nice to hear.

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

[@pavankotharu]

Amazing Video. Clean and clear. Please keep posting more

[@Computergaga]

Thank you, I will 😊

[@russellcolumbo5426]

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

[@Computergaga]

Thank you Russell 😊

[@staticplayz7377]

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

[@Computergaga]

You're welcome! 👍

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

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

[@TheGroovisthecat]

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

[@josephfarrugia5829]

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

[@Computergaga]

Great to hear. Thanks Joseph.

[@lindamatrone6827]

Awesome Vlookup video, super clear and very useful

[@Computergaga]

Thank you Linda.

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

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

[@dunlapg75]

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

[@Computergaga]

Happy to help.

[@moekraft]

Thank you! My first time running a VLookup and you made it so simple! : )

[@Computergaga]

Excellent! So happy to hear that Maureen.

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

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

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

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

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

[@navinhurree7301]

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

[@Computergaga]

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

[@punjabiG]

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

[@Computergaga]

Awesome!!

[@jorgeochoaleon]

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

[@Computergaga]

Thank you Jorge.

[@thabonape5247]

You're a superhero for this one. Thank you

[@Computergaga]

You're welcome. Thanks.

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

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

[@jaylakhani5568]

Thanks mate, saved me on a uni project for accounting

[@world752]

Man, you deserve a million sub

[@Computergaga]

Thank you very much.

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

[@reubenkaseba5712]

This was so much fun to watch. As a person who uses excel on a daily, thank you very much 🙏

[@Computergaga]

Thanks, Reuben.

[@kingoflame2031]

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

[@Computergaga]

Excellent!!

[@sidharthjaiswal]

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

[@Computergaga]

Thank you Sidharth.

[@serenitymassage9671]

You just saved my sleep. Thank you. Finally someone who explains vlookup clearly.

[@Computergaga]

You're welcome, thank you.

[@FuzzCaminski]

This is a lifesaver, thank you for a clear and logical explanation

[@Computergaga]

My pleasure. Thank you Paul.

[@lucywere8794]

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

[@Computergaga]

Great! No worries.

[@TitChheang]

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

[@Computergaga]

You're so welcome!

[@GarethNIreland]

Worked for me - English competence at its best 👍🏻

[@Computergaga]

Excellent!

[@jenniferrose7346]

Great instructions. Very easy to follow. Thank you!

[@Computergaga]

You're very welcome, Jennifer. Thank you.

[@pradeepap9365]

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

[@Computergaga]

Glad it helped! You're welcome, Pradeepa.

[@grahamefernback9079]

A really simple and explanatory video that cured my absolute fear of VLOOKUP. Once mastered (because of the video) so simple. to use. Any videos on splitting text in a cell - causing me big problems.

[@Computergaga]

Thank you Grahame. Sure, I have this one with Text to Columns - kzbin.info/www/bejne/rorWdJ2ir8-YqbM I have plenty of others using formulas or Power Query to split text.

[@eduarmon2128]

Boy did I need this. Thank you

[@Computergaga]

My pleasure.

[@andywithers592]

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

[@Computergaga]

You're welcome, Andy.

[@amofavirtuosomichael2586]

Fantastic video of all time.

[@Computergaga]

👍 😊

[@pfanomukhodobwane1666]

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

[@Computergaga]

Great to hear, Pfano. You're welcome.

[@ZainKhan-jv9wp]

Thank You So It Worked I was worried to find duplicate Data from 20000 Rows of two sheets this make me much easier to find Thank you So Much Live Long.

[@Computergaga]

You're welcome, Zain. Happy to help.

[@BereccaSmith]

This is an excellent explanation, thank you!

[@Computergaga]

You're welcome. Thank you Rebecca.

[@micahellis1343]

I don't mean to be weird, but your voice is so soothing!

[@Computergaga]

Thank you :)

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

[@yousufsohan4097]

hello thank you your video is great could you add the calculation of missing items as the list is large

[@awad2584]

Oh man, you are THE best. Thank you so much🙂

[@Computergaga]

You're welcome! Thank you 😊

[@shaharzohar8616]

Excellent explanation!

[@Computergaga]

Thank you, Shahar.

[@mks2443]

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

[@Computergaga]

Thank you. I'm glad it was helpful.

[@sujitkumar-gk2tb]

Sir u explained it very beautifully

[@Computergaga]

Thank you very much.

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