Compare Two Lists Using the VLOOKUP Formula

แชร์
ฝัง
  • เผยแพร่เมื่อ 30 ม.ค. 2025

ความคิดเห็น • 788

  • @krystinbandy9577
    @krystinbandy9577 5 ปีที่แล้ว +64

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

    • @Computergaga
      @Computergaga  5 ปีที่แล้ว +1

      You're very welcome. Thank you Krystin.

    • @sujithsuji274
      @sujithsuji274 4 ปีที่แล้ว

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

    • @srilekhaj3915
      @srilekhaj3915 3 ปีที่แล้ว

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

    • @nycollassilva3558
      @nycollassilva3558 2 ปีที่แล้ว

      Bn1fcj,

    • @PriyaSingh-ee5ck
      @PriyaSingh-ee5ck ปีที่แล้ว

      Akka valla intiki vellindhi akka akkadiki thisukuni vellanu

  • @drivingwanderlust4202
    @drivingwanderlust4202 5 ปีที่แล้ว +10

    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
      @Computergaga  5 ปีที่แล้ว +1

      Excellent work Sharise.

  • @balajikumar10
    @balajikumar10 3 ปีที่แล้ว

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

    • @Computergaga
      @Computergaga  3 ปีที่แล้ว +1

      Thank you very much, Balaji 😊

  • @kawejoseph2382
    @kawejoseph2382 3 หลายเดือนก่อน +1

    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
    @alvelasquez7157 2 ปีที่แล้ว

    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
      @Computergaga  2 ปีที่แล้ว

      Glad it helped! Thank you 😀

  • @fernandarosenberg2848
    @fernandarosenberg2848 5 ปีที่แล้ว +3

    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
      @Computergaga  5 ปีที่แล้ว

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

  • @samanthad708
    @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
      @Computergaga  ปีที่แล้ว

      You're very welcome, Samantha. Thank you 😊

  • @basheerahmed9095
    @basheerahmed9095 6 ปีที่แล้ว +18

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

    • @Computergaga
      @Computergaga  6 ปีที่แล้ว

      You're welcome Basheer. Thank you.

  • @rubenvargas4233
    @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
      @Computergaga  ปีที่แล้ว

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

  • @suethorpe6952
    @suethorpe6952 6 ปีที่แล้ว +18

    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
      @Computergaga  6 ปีที่แล้ว

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

    • @qatestbrian1
      @qatestbrian1 5 ปีที่แล้ว

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

  • @danielledinse6657
    @danielledinse6657 7 ปีที่แล้ว +2

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

  • @gloriaruiz13
    @gloriaruiz13 4 ปีที่แล้ว

    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
      @Computergaga  4 ปีที่แล้ว

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

  • @stephaniebeard6319
    @stephaniebeard6319 3 ปีที่แล้ว

    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
      @Computergaga  3 ปีที่แล้ว

      Excellent! You're welcome.

  • @w-z198
    @w-z198 2 ปีที่แล้ว

    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
      @Computergaga  2 ปีที่แล้ว

      My pleasure. Thank you for your comment.

  • @egarcia0522
    @egarcia0522 3 ปีที่แล้ว

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

    • @Computergaga
      @Computergaga  3 ปีที่แล้ว

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

  • @sanhanessian6984
    @sanhanessian6984 2 ปีที่แล้ว +1

    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
      @Computergaga  2 ปีที่แล้ว

      Thank you very much 😊 Really glad it helped.

  • @316julius
    @316julius 4 ปีที่แล้ว

    Thank you for making excel life much easier. Best tutorial on TH-cam.

    • @Computergaga
      @Computergaga  4 ปีที่แล้ว

      You're very welcome. Thank you 😊

  • @StarZaan
    @StarZaan 3 ปีที่แล้ว

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

    • @Computergaga
      @Computergaga  3 ปีที่แล้ว

      Brilliant to hear, Riri 👍

  • @MissT813
    @MissT813 3 ปีที่แล้ว

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

  • @lisahorton6824
    @lisahorton6824 3 ปีที่แล้ว

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

  • @genevevev.valenzuela4398
    @genevevev.valenzuela4398 4 ปีที่แล้ว

    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
      @Computergaga  4 ปีที่แล้ว

      Thank you, Monalissa. That is great to hear.

  • @YanBrassard
    @YanBrassard 5 ปีที่แล้ว

    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
      @Computergaga  5 ปีที่แล้ว

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

  • @mdtaylor2274
    @mdtaylor2274 6 ปีที่แล้ว +2

    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
      @Computergaga  6 ปีที่แล้ว +1

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

    • @mdtaylor2274
      @mdtaylor2274 6 ปีที่แล้ว +1

      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
      @Computergaga  6 ปีที่แล้ว

      Thank you Michael. We are connected on LinkedIn :)

  • @akhilsadanandan2139
    @akhilsadanandan2139 4 ปีที่แล้ว

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

    • @Computergaga
      @Computergaga  4 ปีที่แล้ว +1

      That is great to hear. Thank you, Akhil.

  • @richardgordon
    @richardgordon 2 ปีที่แล้ว +1

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

  • @aarongodwin1000
    @aarongodwin1000 4 ปีที่แล้ว +1

    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
      @Computergaga  4 ปีที่แล้ว

      Great to hear.

    • @SIMRANKAUR-eg7nc
      @SIMRANKAUR-eg7nc 4 ปีที่แล้ว

      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.
      th-cam.com/video/5fsmy3uwoc8/w-d-xo.html

  • @qatestbrian1
    @qatestbrian1 5 ปีที่แล้ว

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

    • @Computergaga
      @Computergaga  5 ปีที่แล้ว +1

      Thank you very much Adrian.

  • @ratulahmed2823
    @ratulahmed2823 6 ปีที่แล้ว +23

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

    • @Computergaga
      @Computergaga  6 ปีที่แล้ว +3

      Great to hear. Happy to help Ratul.

    • @amanuelamente6214
      @amanuelamente6214 4 ปีที่แล้ว

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

  • @shenitamarr4517
    @shenitamarr4517 5 ปีที่แล้ว +1

    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
      @Computergaga  5 ปีที่แล้ว

      Thank you very much Shenita.

  • @sarahwhite7052
    @sarahwhite7052 4 ปีที่แล้ว

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

    • @Computergaga
      @Computergaga  4 ปีที่แล้ว

      Thank you very much Sarah 😊

  • @BeenHereYet
    @BeenHereYet 4 ปีที่แล้ว +11

    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
      @Computergaga  4 ปีที่แล้ว +1

      Excellent to hear. Thank you Lance.

  • @qaz9258
    @qaz9258 5 ปีที่แล้ว

    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
      @qaz9258 5 ปีที่แล้ว

      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
      @Computergaga  5 ปีที่แล้ว

      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
      @qaz9258 5 ปีที่แล้ว

      @@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
      @Computergaga  5 ปีที่แล้ว +1

      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
      @qaz9258 5 ปีที่แล้ว

      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

  • @Andy766702
    @Andy766702 4 ปีที่แล้ว

    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
      @Computergaga  4 ปีที่แล้ว

      That is great to hear. Thank you, Andy.

  • @traviskent3108
    @traviskent3108 2 ปีที่แล้ว +1

    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.

  • @hankgrimes1806
    @hankgrimes1806 5 ปีที่แล้ว +1

    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
      @Computergaga  5 ปีที่แล้ว

      Thank you Hank. You're welcome.

  • @irasemalahoz5053
    @irasemalahoz5053 3 ปีที่แล้ว

    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
      @Computergaga  3 ปีที่แล้ว

      You're very welcome! Thank you, Irasema.

  • @MargaretUK
    @MargaretUK 2 ปีที่แล้ว

    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
      @Computergaga  2 ปีที่แล้ว +1

      Thank you Margaret. Your comments are appreciated.

  • @edenteuira-hussein8121
    @edenteuira-hussein8121 3 ปีที่แล้ว

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

    • @Computergaga
      @Computergaga  3 ปีที่แล้ว

      You're very welcome 👍

  • @wan12345
    @wan12345 3 ปีที่แล้ว

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

    • @Computergaga
      @Computergaga  3 ปีที่แล้ว +1

      My pleasure. Great to hear that it helped.

  • @erinadinu8585
    @erinadinu8585 5 ปีที่แล้ว +3

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

    • @Computergaga
      @Computergaga  5 ปีที่แล้ว +1

      It sure is. My pleasure Irina.

  • @GS-uc9yl
    @GS-uc9yl ปีที่แล้ว

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

    • @Computergaga
      @Computergaga  ปีที่แล้ว +1

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

  • @jonchapman621
    @jonchapman621 4 ปีที่แล้ว

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

    • @Computergaga
      @Computergaga  4 ปีที่แล้ว

      My pleasure. That is great to hear Jon.

  • @segunplay
    @segunplay ปีที่แล้ว

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

  • @russellcolumbo5426
    @russellcolumbo5426 3 ปีที่แล้ว

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

  • @zhaozhang4047
    @zhaozhang4047 7 ปีที่แล้ว

    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
      @Computergaga  7 ปีที่แล้ว

      Absolutely you can do this.

  • @ExcelSquad
    @ExcelSquad 6 ปีที่แล้ว +1

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

    • @Computergaga
      @Computergaga  6 ปีที่แล้ว

      Thanks Raju. Very nice to hear.

  • @pavankotharu
    @pavankotharu 4 ปีที่แล้ว +1

    Amazing Video. Clean and clear. Please keep posting more

  • @dunlapg75
    @dunlapg75 2 ปีที่แล้ว

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

  • @navinhurree7301
    @navinhurree7301 4 ปีที่แล้ว

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

    • @Computergaga
      @Computergaga  4 ปีที่แล้ว

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

  • @cathyb2204
    @cathyb2204 6 ปีที่แล้ว +2

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

    • @Computergaga
      @Computergaga  6 ปีที่แล้ว

      Happy to be of help Cathy.

    • @mazabrady4337
      @mazabrady4337 4 ปีที่แล้ว

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

  • @roxylovingly
    @roxylovingly 2 ปีที่แล้ว +1

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

  • @marutiprasad6310
    @marutiprasad6310 6 ปีที่แล้ว +5

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

    • @Computergaga
      @Computergaga  6 ปีที่แล้ว +1

      Great to hear. Thank you Maruti.

  • @ann8795
    @ann8795 2 ปีที่แล้ว

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

    • @Computergaga
      @Computergaga  2 ปีที่แล้ว

      That's fantastic. My pleasure Ann.

  • @grahamefernback9079
    @grahamefernback9079 4 ปีที่แล้ว

    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
      @Computergaga  4 ปีที่แล้ว

      Thank you Grahame. Sure, I have this one with Text to Columns - th-cam.com/video/xYsCjlzjesQ/w-d-xo.html I have plenty of others using formulas or Power Query to split text.

  • @staticplayz7377
    @staticplayz7377 ปีที่แล้ว

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

  • @bashgalsport
    @bashgalsport 3 ปีที่แล้ว

    Thank you so much for the video!

  • @sparshbhasin18
    @sparshbhasin18 6 ปีที่แล้ว +5

    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
      @Computergaga  6 ปีที่แล้ว +1

      No problem. Glad it is working out for you.

  • @lessyara1129
    @lessyara1129 5 ปีที่แล้ว +1

    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
      @Computergaga  5 ปีที่แล้ว

      Thank you very much Amsy.

  • @TheAkliukai
    @TheAkliukai 5 ปีที่แล้ว +1

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

    • @Computergaga
      @Computergaga  5 ปีที่แล้ว +1

      Thank you very much Arnie.

  • @jorgeochoaleon
    @jorgeochoaleon 5 ปีที่แล้ว +1

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

  • @reubenkaseba5712
    @reubenkaseba5712 3 ปีที่แล้ว

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

  • @sureshvaghela1984
    @sureshvaghela1984 3 ปีที่แล้ว

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

  • @anishmalik6474
    @anishmalik6474 7 ปีที่แล้ว +1

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

  • @avelyndelacruz582
    @avelyndelacruz582 4 หลายเดือนก่อน

    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
      @Computergaga  4 หลายเดือนก่อน

      You're welcome! Thank you for your comments.

  • @ZainKhan-jv9wp
    @ZainKhan-jv9wp 3 ปีที่แล้ว

    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
      @Computergaga  3 ปีที่แล้ว

      You're welcome, Zain. Happy to help.

  • @laptopdigitalli7387
    @laptopdigitalli7387 5 ปีที่แล้ว

    Excellent tutorial. Computergaga you rock. Welldone.

  • @TheGroovisthecat
    @TheGroovisthecat 4 ปีที่แล้ว +8

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

  • @mindytu3895
    @mindytu3895 6 ปีที่แล้ว +4

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

  • @buddhikaperera5716
    @buddhikaperera5716 4 ปีที่แล้ว

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

    • @Computergaga
      @Computergaga  4 ปีที่แล้ว

      That is great to hear, Buddhika. Thank you.

  • @punjabiG
    @punjabiG 2 ปีที่แล้ว

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

  • @fostero922010
    @fostero922010 6 ปีที่แล้ว +6

    This is the most helpful tutorial ever! Many thanks!

  • @jenniferrose7346
    @jenniferrose7346 2 ปีที่แล้ว

    Great instructions. Very easy to follow. Thank you!

    • @Computergaga
      @Computergaga  2 ปีที่แล้ว

      You're very welcome, Jennifer. Thank you.

  • @TitChheang
    @TitChheang 6 หลายเดือนก่อน

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

    • @Computergaga
      @Computergaga  6 หลายเดือนก่อน

      You're so welcome!

  • @andywithers592
    @andywithers592 4 ปีที่แล้ว

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

  • @GarethNIreland
    @GarethNIreland 3 ปีที่แล้ว

    Worked for me - English competence at its best 👍🏻

  • @josephfarrugia5829
    @josephfarrugia5829 6 ปีที่แล้ว +1

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

    • @Computergaga
      @Computergaga  6 ปีที่แล้ว

      Great to hear. Thanks Joseph.

  • @randoriryan
    @randoriryan 4 ปีที่แล้ว +8

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

  • @ivarification
    @ivarification 4 ปีที่แล้ว

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

  • @debrajohnson852
    @debrajohnson852 4 ปีที่แล้ว +1

    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
      @Computergaga  4 ปีที่แล้ว

      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
      @SIMRANKAUR-eg7nc 4 ปีที่แล้ว

      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.

  • @gerryskill5488
    @gerryskill5488 3 ปีที่แล้ว

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

  • @moekraft
    @moekraft 5 ปีที่แล้ว +3

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

    • @Computergaga
      @Computergaga  5 ปีที่แล้ว

      Excellent! So happy to hear that Maureen.

  • @festusmallay459
    @festusmallay459 5 ปีที่แล้ว

    This is worth listing to , it has articulated my thinking and develop more interest in your your presentations

    • @Computergaga
      @Computergaga  5 ปีที่แล้ว

      Thank you Festus. Your comments are appreciated.

  • @lindamatrone6827
    @lindamatrone6827 6 ปีที่แล้ว +2

    Awesome Vlookup video, super clear and very useful

  • @pradeepap9365
    @pradeepap9365 4 ปีที่แล้ว

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

    • @Computergaga
      @Computergaga  4 ปีที่แล้ว

      Glad it helped! You're welcome, Pradeepa.

  • @aaronanthony3190
    @aaronanthony3190 7 ปีที่แล้ว +3

    Amazing!! Thank you so much for your guidance and way of explaining this function!

    • @Computergaga
      @Computergaga  7 ปีที่แล้ว

      Your welcome Aaron, thank you.

  • @bigbadstig
    @bigbadstig 5 ปีที่แล้ว

    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
      @Computergaga  5 ปีที่แล้ว

      Glad to be of help. I have a video on doing a VLOOKUP on first and last name here - th-cam.com/video/ZqWTsmk2Jk8/w-d-xo.html You can combine this technique with what is shown to compare lists.

    • @bigbadstig
      @bigbadstig 5 ปีที่แล้ว

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

  • @lucywere8794
    @lucywere8794 ปีที่แล้ว

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

  • @balasundareshwarana.766
    @balasundareshwarana.766 5 ปีที่แล้ว

    Well, Thank You! It is just awesome the way you presented all intriguing details!
    Just one thing... I had no patience or just had to see your video in 2.0 speed .. and also clear audio in that speed!

  • @suresh25692
    @suresh25692 2 ปีที่แล้ว

    👏🏻 awesome, u taught me exactly i was looking for. Great job.

    • @Computergaga
      @Computergaga  2 ปีที่แล้ว

      Brilliant! Happy to have helped.

    • @suresh25692
      @suresh25692 2 ปีที่แล้ว

      @@Computergaga i am facing a new challenge while using vlook up between two sheets, getting NA error even after ensuring character limit, cell type as general using “Text to column”. This issue occurs within the table however if i use the same vlookup outside the table then it works perfectly fine. Do i miss something!!! Would be a great help.

    • @Computergaga
      @Computergaga  2 ปีที่แล้ว

      Are all of them returning #N/A?
      It's difficult for me to know the problem without seeing the sheet.

  • @pfanomukhodobwane1666
    @pfanomukhodobwane1666 3 ปีที่แล้ว

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

    • @Computergaga
      @Computergaga  3 ปีที่แล้ว

      Great to hear, Pfano. You're welcome.

  • @mks2443
    @mks2443 ปีที่แล้ว

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

    • @Computergaga
      @Computergaga  ปีที่แล้ว

      Thank you. I'm glad it was helpful.

  • @Sendu108
    @Sendu108 5 ปีที่แล้ว

    Do you have the workbooks for download so we can work along with you? Thanks for the video regardless

    • @Computergaga
      @Computergaga  5 ปีที่แล้ว +1

      Thank you. I do sometimes provide files with videos, unfortunately not for this one though.

  • @TheVenueSearcher
    @TheVenueSearcher 3 ปีที่แล้ว +3

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

    • @TheVenueSearcher
      @TheVenueSearcher 3 ปีที่แล้ว

      THIS BY FAR THE BEST EXPLANATION EVER ON TH-cam!

    • @Computergaga
      @Computergaga  3 ปีที่แล้ว

      You're very welcome. Thank you 😊

  • @micahellis1343
    @micahellis1343 6 ปีที่แล้ว

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

  • @fierymusic1572
    @fierymusic1572 5 ปีที่แล้ว

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

  • @audreyscakes
    @audreyscakes 3 ปีที่แล้ว

    this was so great! i was able to follow along with my report and replicate the steps, only step that did not work was highlighting the cells, it seemed to highlight everything even after i used the formula. have to figure it out. thank you

    • @Computergaga
      @Computergaga  3 ปีที่แล้ว

      Thanks you. Might be the $ sign and where it was entered. I hope you figure it out.

  • @thanosy
    @thanosy 6 ปีที่แล้ว +1

    You are the best! Your videos have really helped me. Thank you very much!

    • @Computergaga
      @Computergaga  6 ปีที่แล้ว +1

      You are very welcome. Thank you.

  • @ahmedgaber190
    @ahmedgaber190 6 ปีที่แล้ว

    thank you so much for the great explaination
    and I have a suggestion for you
    why you couldn't put the work sheet in every videos on the description below the video to make it easy for us to understand quickly ?

  • @thabonape5247
    @thabonape5247 3 ปีที่แล้ว +1

    You're a superhero for this one. Thank you

  • @world752
    @world752 5 ปีที่แล้ว +4

    Man, you deserve a million sub