A VLOOKUP Secret Revealed - See How to Impress Your audience

Поділитися
Вставка
  • Опубліковано 18 вер 2024
  • Learn about the Hidden Secret of the VLOOKUP function.
    In this Tutorial I show you how to delete one of the main arguments of our VLOOKUP functions and have the function work as usual.
    You can Download the Exercise file and follow along by clicking on the link:
    www.amazon.ca/...
    If you want to become more confident in using Excel, make sure you read my blog articles & join my newsletter at
    www.See-How.ca
    Book your Corporate Training with me at:
    www.OfficeInstructor.com
    Your feedback motivates me so don't forget to Like , Share and comment... above all hit the subscribe button to be notified when new videos are released... The Best Is Yet To Come.

КОМЕНТАРІ • 44

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

    Thank you and well received

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

    شكراً استاذ نبيل 🌷

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

    Mr. Nabeel you are a great teacher and the way you are teaching is absolutely commendable. I learned a very good trick of V-lookup :)

  • @HariKumar-ru9no
    @HariKumar-ru9no 3 роки тому

    I have seen many vlookup videos. But this one was very deatail and master piece.. Thank u for sharing the hidden secrets in vlookup function..

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

    Super trick

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

    Beautiful! Thanks

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

    Great sir it blow me up a bit thanks.

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

    Your way of delivering knowledge compel me to watch full video even though some times I have the knowledge of same. Keep it up.

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

    i have seen many channels but the way you explains it makes easy to understand. thank you for putting your efforts for me so i can learn from you. i really appreciate your time.

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

    Excellent

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

    Great work

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

    Good explanation

  • @mohammadmohammad-yv4md
    @mohammadmohammad-yv4md 5 років тому +1

    Awesomesauce Nabeel Moraad.
    Ur way of delivering is prodigious

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

    Very good

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

    That is more than great..
    🌟 🌟 🌟 🌟 🌟 Thanks indeed. 👍 Thumbs up.. 🌟
    Best regards from Germany..

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

      Thank you Salim... Greetings from Toronto Canada

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

    great job, we proud in you Mr. Nabil Mourad
    greeting form Yemen

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

      Thank you Najib... Greetings from Toronto Canada

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

    Thanks! You deserve 100 000 subscribers.

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

      Thank you Aleksandrs for the nice comment and motivation.... It's great to feel appreciated.
      it's for people like YOU that I will keep doing the great effort that I'm currently doing

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

    You are good. Thank you. David

  • @ZAHIDHUSSAIN-ri5kg
    @ZAHIDHUSSAIN-ri5kg 5 років тому

    Excellent...what a great video!

  • @alializadeh8195
    @alializadeh8195 Рік тому

    thanks

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

    that was amazing thanks a lot sir.

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

      Thank you for being a loyal follower. and I appreciate all you nice comments

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

    You are awesome, man!

  • @rajuar1955
    @rajuar1955 5 років тому +2

    Excellent Sir . Please make a Excel Interview Questions video Thanks.

    • @Officeinstructor
      @Officeinstructor  5 років тому +2

      Thanks for the great idea... can do that some time in the future

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

    Nice trick, thank you Nabil!

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

    Thank you, that was an excellent tip

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

    Excellent trick 😘

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

    Amazing

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

    Is there any limitation of row number if we select to hard code the lookup array

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

    What if after hide it, and u want to add same formula to another cell, will d hiden prevent it from happen

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

    i am your new student

  • @HariKumar-ru9no
    @HariKumar-ru9no 3 роки тому

    How to remove protect sheet on vlookup formulae. Pls advice.

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

      Do you mean remove protection from the exercise file you are getting for FREE? of course you can't

    • @HariKumar-ru9no
      @HariKumar-ru9no 3 роки тому

      Hello sir, when F9 Pressed after that I want to remove table of array in vlook up function. Pls tell sir.