Vlookup with IF Formula in Excel in Hindi

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

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

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

    Thank you Sir aapne bahut acche se sikhaya. 😊🙏👍
    Sir, Tomorrow I will go for MIS Executive job Interview. 😊

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

    Dear sir salute to you as your excel.videos are amazing and also learning a lot from it hats off to you sir Really you are doing very nice job

  • @noorqamar7580
    @noorqamar7580 5 лет назад +3

    GREAT SIR G! YOU ARE DOING THE BEST.

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

    Excellent way sir ! God bless you.

  • @AbhishekMishra-cr1tz
    @AbhishekMishra-cr1tz 5 лет назад

    बहुत अच्छा लगा लाजवाब

  • @RashidKhan-ei8mn
    @RashidKhan-ei8mn 5 лет назад +1

    Wonderful sir thank we use index and match like this?

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

    Thank you so much. I like the way you explain excel steps. Your explanation is just like excel formula =simple and easy to learn.

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

      Thanks Ricky

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

    What a lovely video

  • @priteshkhamkar3975
    @priteshkhamkar3975 5 лет назад +2

    Can we use match in same formula?

  • @rohitarora3261
    @rohitarora3261 5 лет назад +1

    Thank You Sir 👍

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

    Kya is formula Ko jyada column s k liye use Kiya ja Sakta hai.

  • @poojaadnani2870
    @poojaadnani2870 5 лет назад +1

    Hi Sir,
    Can you please make a video with some real data which is really huge. As it will be good to see how the formula work on big practical data.

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

    Great Sir

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

    Verry nice

  • @unlimitedGK-om8bs
    @unlimitedGK-om8bs 2 года назад

    🙏🙏🙏 spectacular

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

    बहुत ही लाजवाब फार्मूला है लेकिन सर कोई और इसका कोई शॉर्टकट है जो शार्ट तरीके से काम करके लंबे प्रोसेस को आसान बना सके

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

    Great

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

    Hi Sir, Ihave a data with two criterias im unable to do vlookup with if function can u please help me on this..

  • @92kumarmanoj58
    @92kumarmanoj58 4 года назад

    Nice video

  • @aminshah3181
    @aminshah3181 5 лет назад

    Sir, can you also add in which scenario above formula can be used ?

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

    agar dono mein no. ho to ISTEXT ki jagah kya formula use karenge?

  • @rakeshprajapati3248
    @rakeshprajapati3248 5 лет назад

    Hi, sir can you help me to put vlookup if it match with other cell like I have the modle and it have some parts but same parts is also available with the other model also but the price is different as per the model and we have variety of different parts.

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

    (1)Sir,how to exchange two rows automatically,(both rows with vlookup formula),if value in first is smaller to next row?
    (2)How to add serial no.in a cell after every click from drop down list.which is to be start from sr.no.1 on first day of every month?

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

      Hello sir,
      Hvlookup, index explain kr do sir

  • @Pradeepyadav-fj1dp
    @Pradeepyadav-fj1dp 3 года назад

    sir Agar 1 column mai kuchh cell value hai but khuchh cell khali hai to khali wale pe vlook up kaise lagaye vlookup with isblank formula

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

    Thanks

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

    Sir .... single like not enough for you video's.

  • @RohitKumar-uy7cx
    @RohitKumar-uy7cx 5 лет назад

    Nice vedio sir

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

    Sir, agr hum ye formula jyada columns pe kase apply kre

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

      Thank you for the question, we will get back to you soon. In the meanwhile please visit www.myelesson.org for more excel resources

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

    Sir agr id ke jagah koi text rhe to kon sa formula lgayenge

  • @godhan1000
    @godhan1000 5 лет назад +1

    Superb trick sir
    सर अगर जब एम्पलाई नंबर रिपीट हो रही हो अंतिम एंप्लोई नंबर का रिकॉर्ड निकालना हो तब कैसे करेंगे।

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

    I have 1 query related to my data can you help to resolve this.

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

    Wao

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

    Optional subject result formula batao plz

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

    I think it can be achieved by using DGET function

  • @himanshuratansrivastava
    @himanshuratansrivastava 5 лет назад +1

    Thank you sir 🙂

    • @GuruJii
      @GuruJii  5 лет назад +1

      Welcome Himanshu ji

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

    What if both lookup values are in test or number

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

    Sir agar dono row me number he to kese lagega

  • @arvin4892
    @arvin4892 5 лет назад +1

    Sir ek Imp. chiz btana to bhool gye,,ki ye form. if with vlookup hum kab use krte h?? Rply pls......

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

    Is se easy he double vlook up..

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

    Ek table ki figure ko different table se compile kaise karein

  • @khushalbisht2831
    @khushalbisht2831 5 лет назад +1

    This formula doesn't work Excel 2007 why?

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

    I want to get name by Vlookup behalf ID and don't use choose function, index function and match functions

  • @nidhitasaini5895
    @nidhitasaini5895 5 лет назад +1

    Sir college mein fees mgt kaise krte hai excel mein video bnaye sir pls 🙏reply

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

    Sir i have a pic of data. I need a formula for that

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

    Sir me tally ko excel per kaam kerna chata hu

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

    advance excel formulaS uplood korun . all advance excel formulaS uplood korum.

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

    Answer me error aa rahe

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

    अगर 100 बच्चों को 22 टीचरों के ग्रुप में बांटकर शैक्षणिक भ्रमण पर ले जाना है यह कैसे संभव होगा कि प्रत्येक टीचर पर इन 100 बच्चों में कुछ संख्या में छात्र आ जाएं और वह छात्र और टीचर अपने एक ग्रुप में रहे इसी तरह से सारे बच्चे सभी टीचर पर मैनेज हो जाएं कृपया बताएं

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

    agar Sameer naam likhe toh?

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

    Aager id phle no pe hui to 😇

  • @SanjaySingh-tt5fv
    @SanjaySingh-tt5fv 4 года назад

    Gourges istext

  • @khrifat2319
    @khrifat2319 5 лет назад

    Thanks