LOOKUP Functions in Excel VLOOKUP, HLOOKUP, INDEX MATCH, XLOOKUP Tutorial

Поделиться
HTML-код
  • Опубликовано: 6 янв 2025

Комментарии • 65

  • @SimonSezIT
    @SimonSezIT  4 года назад +6

    Download the instructor files and follow along! www.simonsezit.com/excel-biz-analysis-instructor-files/

    • @SleepEatWorkRepeat
      @SleepEatWorkRepeat 3 года назад

      Why do none of these links work? They never send the downloads to my email.

    • @victormayer5665
      @victormayer5665 2 года назад

      the files are not available anymore...

    • @dexxxxxxxx
      @dexxxxxxxx 2 года назад

      Links not working

  • @realHAUTEcre
    @realHAUTEcre 3 года назад +13

    I've been using Excel for over 30 years, and the presentation and syntax of this course and its content is among the best I've ever experienced. Makes diving into the Black Hole of Excel fun and interesting!

  • @sargonkheedo
    @sargonkheedo 4 года назад +2

    Deb, is the best of the best... thank you Simon Sez it... this is by far the most detailed easy to learn .. thank you

  • @realvirtualdemand4222
    @realvirtualdemand4222 2 года назад +2

    this is a great tutorial and how to get out excel skills up to par..

  • @cliffordeaton5455
    @cliffordeaton5455 4 года назад +5

    Thank you so much for the great instructional videos. For newbies like me, they're worth their weight in gold!

  • @genesisfincorp88
    @genesisfincorp88 Год назад +1

    It is wonder session of advance excel. learnt a lot. ❤❤

    • @SimonSezIT
      @SimonSezIT  Год назад

      Glad you think so!😊 We have additional free Excel training here 👉
      ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training 👉ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u

  • @ziaglos
    @ziaglos 3 года назад +2

    Just like it.
    Thank you Deb 👏👏👍

  • @bhavnakawa1299
    @bhavnakawa1299 3 года назад +4

    I have not received the support file either

  • @nstcoffice3533
    @nstcoffice3533 Год назад

    Thank you for such a nice tutorial

  • @justinoroy
    @justinoroy 3 года назад +3

    Thank u so much, keep doing great!

    • @SimonSezIT
      @SimonSezIT  3 года назад

      Thanks for watching Justino!

  • @black90ify
    @black90ify 3 года назад +4

    we are not receiving any e-mail to download the supported file . will you check this issue

  • @jamesdep8128
    @jamesdep8128 3 года назад +2

    Great class. Thank you again!

    • @SimonSezIT
      @SimonSezIT  3 года назад +1

      Thanks for watching James!🙃

    • @jamesdep8128
      @jamesdep8128 3 года назад

      @@SimonSezIT I am watching all of your videos. it is greatly helping me in my training.

  • @idowumayowadavid886
    @idowumayowadavid886 Год назад

    Thanks so much . I just received the file for free

    • @SimonSezIT
      @SimonSezIT  Год назад

      Great! We have additional free Excel training here 👉
      ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training 👉ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u

  • @IsingomaMugishaChristopher
    @IsingomaMugishaChristopher 3 месяца назад

    thank you ma'am

    • @SimonSezIT
      @SimonSezIT  3 месяца назад

      You are very welcome! 😃 Learn more Microsoft Excel Tips and Tricks here ➡️
      ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

  • @shijogeorgethomas7830
    @shijogeorgethomas7830 2 года назад

    Perfect Explanation🙂

  • @1sornram
    @1sornram 2 года назад +1

    so freaking helpful! thanks a bunch

  • @amitpanchal135
    @amitpanchal135 2 года назад

    I am so glad mam from meet you

  • @poodleseigien
    @poodleseigien 3 года назад

    Best instructor!

  • @TVSCDN
    @TVSCDN Год назад

    Thanks madam🎉🎉🎉❤❤❤😊

  • @jessieren1296
    @jessieren1296 2 года назад

    It helps a lot! Thank you so so much!

  • @magtulunganpinoy5597
    @magtulunganpinoy5597 2 года назад

    thanks soooooo much!!!!!

  • @chutatipwattana399
    @chutatipwattana399 3 года назад +1

    Thank you!!

  • @lisapenfold2979
    @lisapenfold2979 2 года назад

    great video.
    thanks.

    • @SimonSezIT
      @SimonSezIT  2 года назад

      Thanks for the nice comments, Lisa 😊

  • @z-spotinternational165
    @z-spotinternational165 2 года назад

    I have subscribed to the excel file already but i dun see the work file being sent - its not in the spam folder either

  • @nikush1631
    @nikush1631 Год назад

    Is the final module available for this online as well? Thanks for all that you do, starting a new job Monday and these videos are so helpful!

  • @ianrobertson5128
    @ianrobertson5128 4 года назад +2

    Do you do videos on Excel for Mac 365?
    These are fabulous but the Mac version is different in some spots.

    • @SimonSezIT
      @SimonSezIT  4 года назад

      Thanks Ian, Delighted you are enjoying the tutorials and thanks for letting me know what you are looking for, we'll see what we can do:
      Our Excel for Mac Tutorials are currently beginner level:ruclips.net/video/sYU4k0P8c5g/видео.html

  • @athennasamelin425
    @athennasamelin425 2 года назад

    hii, if you don't mind, can I ask the reference you've used in Index Match (Market Research: Revenue and Profit for Popular Iphone Apps)? thank youuu

  • @z-spotinternational165
    @z-spotinternational165 2 года назад

    the file has not gone to any SPAM Sir... hope you are able to help out with this

  • @sandhyarani362
    @sandhyarani362 Год назад

    will u make a video on excel 2007

    • @SimonSezIT
      @SimonSezIT  Год назад

      We do have some older tutorial videos on Excel 2007. Check out this playlist ➡️ruclips.net/p/PLzj7TwUeMQ3gIjaQf5o75BrEeaSF2cg_j

  • @idowumayowadavid886
    @idowumayowadavid886 Год назад

    Please I really wish to get access to the file promised in the video.
    I have given my email details but I am yet to receive any file.

  • @RY-ey7dx
    @RY-ey7dx 2 года назад

    For some reason, the instructor files to follow along are not accessible. the link returns a blank webpage :(

    • @SimonSezIT
      @SimonSezIT  2 года назад +1

      Hi RY. Sorry about that. Please try clearing your cache or try another web browser.

    • @RY-ey7dx
      @RY-ey7dx 2 года назад

      @@SimonSezIT thanks.

  • @hapemokenela7388
    @hapemokenela7388 3 года назад +1

    i didn't receive an email for the download link. Please reply.Thank You.

    • @SimonSezIT
      @SimonSezIT  2 года назад +1

      Please check your spam folder.

  • @prathyushasegu4991
    @prathyushasegu4991 3 года назад +1

    HI Mam, Can you share a vedio by using Unit price inplace of Part No.

    • @hestiaa9354
      @hestiaa9354 2 года назад

      I don’t know if that will work. The unit prices might be the same for several items. How would VLookup know which one to select?

  • @aydaneliyeva4682
    @aydaneliyeva4682 3 года назад

    why doesnt work file?(

  • @aradhyarathi2048
    @aradhyarathi2048 4 года назад +1

    Please send the document of VLOOKUP true statement for practice in my reply.

    • @SimonSezIT
      @SimonSezIT  4 года назад

      You can download the instructor files for this video here: www.simonsezit.com/excel-biz-analysis-instructor-files/

    • @aradhyarathi2048
      @aradhyarathi2048 4 года назад

      @@SimonSezIT Thank you !!

  • @dexxxxxxxx
    @dexxxxxxxx 2 года назад

    27:26

  • @ememanduquincy8457
    @ememanduquincy8457 3 года назад +1

    Can you make include timestamps to such a long video?

    • @SimonSezIT
      @SimonSezIT  3 года назад

      Thank you for the feedback, we'll see what we can do.

  • @dessleonid
    @dessleonid 11 месяцев назад

    Nope I didn't get the result of 57 and 52 but 100 and 100 on those cells while doing your shitty match + vlookup. Why? This is BS. Why do you need this complication with match formula while just Vlookup formula manages its work pretty damn good of its own accord?