☑️ 19 Things You Need To Know About VLOOKUP In Excel

Поділитися
Вставка
  • Опубліковано 29 жов 2024

КОМЕНТАРІ • 62

  • @HowToExcelBlog
    @HowToExcelBlog  4 роки тому +1

    Check out my full courses and ebooks here
    👉 www.howtoexcel.org/courses/

  • @winsbury
    @winsbury 4 роки тому +1

    Probably the best vlookup help video I have watched. Thanks

  • @clairejsquibb
    @clairejsquibb 5 років тому +6

    Really thorough, and I hadn't thought of using CHOOSE for a leftward lookup - great tip!

    • @HowToExcelBlog
      @HowToExcelBlog  5 років тому

      Yes, I became a bigger fan of CHOOSE when I discovered that trick!

    • @HowToExcelBlog
      @HowToExcelBlog  5 років тому

      Do you have any favourite VLOOKUP tricks?

    • @KishanGupta243
      @KishanGupta243 4 роки тому

      @@HowToExcelBlog if i want lookup 20 column value.how this formula work.

    • @KishanGupta243
      @KishanGupta243 4 роки тому

      do i have to write 20 time in choose function like choose{1,2,3,4,5,6,7,8,......20}

  • @franciscoespinosa6810
    @franciscoespinosa6810 2 роки тому

    Thanks so much, I learned a lot.

  • @naveedyousaf1657
    @naveedyousaf1657 4 роки тому +2

    Very helpful. I have learnt new things even though i am using VLOOKUP since a long time.
    Thanks

    • @HowToExcelBlog
      @HowToExcelBlog  4 роки тому

      There's always some new detail to learn in Excel!

  • @mrmrafee
    @mrmrafee 5 років тому +1

    I got benefited from this, So it’s not fare to leave without appreciation you. Thank you and god bless you. Regards

    • @HowToExcelBlog
      @HowToExcelBlog  5 років тому +1

      I appreciate the comment, glad to hear it benefited you!

  • @timifinnih3819
    @timifinnih3819 4 роки тому +1

    Very enlightening. Thank you

  • @YTmaniac
    @YTmaniac 5 років тому +1

    Excellent video of tips! I have used VLOOKUP with named arrays or tables before, but nice to see these other options without naming the array or table.

    • @HowToExcelBlog
      @HowToExcelBlog  5 років тому

      Yes, there are usually lots of ways to do something in Excel!
      Do you have any other VLOOKUP tips?

  • @RT-jf9pp
    @RT-jf9pp 4 роки тому +1

    You have a very easy to listen to voice. Great pace too!

  • @wayneedmondson1065
    @wayneedmondson1065 5 років тому +1

    Hi John.. great video! Very comprehensive. I can't think of anything you left out. Even though I'm familiar with and use VLOOKUP often, this was a super review and brain tickler to remember all of the important things to know about VLOOKUP. Thanks and Thumbs up!!
    PS - I watch a lot of EXCEL videos and I think your style and presentation is superior. I find your videos engaging and interesting, as well as informative and relevant. I'm here to learn and so enjoy the fact that you keep it about EXCEL and not about trying to entertain or grandstand. So.. I'm a fan : )) Keep them coming! One thing.. any chance of providing links to your example worksheets for those who like to follow along? I can always re-create a short data set, but it's a nice time saver to get a download link.. just a thought or suggestion. Thanks again.

    • @HowToExcelBlog
      @HowToExcelBlog  5 років тому +1

      Good idea Wayne! I'll try to add the workbooks to the last few videos in the next couple days and to all videos going forward.

    • @wayneedmondson1065
      @wayneedmondson1065 5 років тому

      @@HowToExcelBlog Thanks John.. that would be great. I like to follow along and so if on the same data set, can match what you do in the video. Looking forward to it. Thumbs up!

  • @kansa1000
    @kansa1000 4 роки тому +1

    Thanks, excellent information.

  • @charlottengetich4865
    @charlottengetich4865 5 років тому +1

    I am new to this and your video is realy helpful and easy to follow. Thank you and be blessed

  • @JanBolhuis
    @JanBolhuis 5 років тому +1

    Thanks for the video. Some great tips.

    • @HowToExcelBlog
      @HowToExcelBlog  5 років тому

      No problem Jan. Any favourites out of them?

  • @amitkumarpoddar448
    @amitkumarpoddar448 4 роки тому

    very helpful tutorial, thanks a lot.

  • @carlosrusten1289
    @carlosrusten1289 4 роки тому +2

    thank you it is exactly what I need

  • @nikolaygizdov860
    @nikolaygizdov860 5 років тому +1

    Hello, John. Thank you for sharing information about VLOOKUP. Extremely useful
    . Realy realy good video. Great video! Keep it going.

    • @HowToExcelBlog
      @HowToExcelBlog  5 років тому

      Hi Nikolay. Glad to hear you enjoyed it!

    • @HowToExcelBlog
      @HowToExcelBlog  5 років тому

      Any other topics you would like to see?

    • @nikolaygizdov860
      @nikolaygizdov860 5 років тому

      @@HowToExcelBlog For whatever you have the readiness and desire. I prefer something with the VBA, but you decide. This video was great!

  • @jamesa.galloway6105
    @jamesa.galloway6105 5 років тому +1

    Hello John, thanks for this information. Does " =IFERROR(=VLOOKUP " work across different worksheet (same workbook) reference? I have been trying get it to work with no success.

    • @HowToExcelBlog
      @HowToExcelBlog  5 років тому

      You probably just need to get rid of the second equal sign in the formula.

  • @samsungaircel6740
    @samsungaircel6740 5 років тому +1

    Great Video!!!

  • @sully199
    @sully199 5 років тому +1

    Great video, thank you

  • @stevennye5075
    @stevennye5075 5 років тому +1

    very useful

  • @mahaboobhossain5076
    @mahaboobhossain5076 4 роки тому +1

    excellent

  • @himanshuagarwal3512
    @himanshuagarwal3512 5 років тому +1

    superb

  • @rileywoodruff7955
    @rileywoodruff7955 3 роки тому +1

    Watched a ton of V lookup videos it finally clicked on this video

    • @HowToExcelBlog
      @HowToExcelBlog  3 роки тому

      Oh, good to hear! Next up, XLOOKUP, the successor to VLOOKUP.

  • @shoppersdream
    @shoppersdream 3 роки тому +1

    Where is the download file for this? Your link only asks to enter your name and email but then we don't get the downloads.

    • @HowToExcelBlog
      @HowToExcelBlog  3 роки тому

      Check you junk, spam or other folders.

    • @shoppersdream
      @shoppersdream 3 роки тому

      @@HowToExcelBlog I checked it and there is nothing. I tried many times and I am not able to download any file. Thanks

  • @louiselane806
    @louiselane806 3 роки тому

    Excellent vidoes however I've subscribed to your newsletter and received nothing!

  • @TheLaopi
    @TheLaopi 2 роки тому

    i don't find thé file ton download 😥

  • @andysmith5997
    @andysmith5997 4 роки тому +4

    19 things!? I didn’t know this much about my wife when I married her
    I’m getting dv’d

    • @HowToExcelBlog
      @HowToExcelBlog  4 роки тому +1

      Haha 😂
      Well, don't marry VLOOKUP just yet because XLOOKUP is coming to Excel soon!