Vlookup with Indirect Function in Excel Hindi | Use INDIRECT to Reference sheets within VLOOKUP

Поділитися
Вставка
  • Опубліковано 25 сер 2024
  • Vlookup with Indirect Function in Excel Hindi | Use INDIRECT to Reference sheets within VLOOKUP.
    #vlookupinexcel #indirectinexcel #computergyanguruji
    Practice file download - drive.google.c...
    Our second channel
    / computergurujitechnical
    www.amazon.in/shop/computergyanguruji
    Follow us on
    instagram
    / computergyanguruji
    Twitter
    / c_g_guruji
    Facebook
    / computer-gyan-guruji-1...
    MS Excel Videos
    • Hindi English Dictiona...
    MS Excel for Beginners
    • MS Excel Tutorial for ...
    Excel VBA
    • Excel VBA
    MS Word
    • MS Word
    MS PowerPoint
    • MS Power Point
    MS Access
    • MS Access tutorial for...
    MS Paint
    • MS Paint
    MSW Logo
    • MSWLogo
    Notepad & HTML
    • Notepad complete tutor...
    CSS
    • Introduction to CSS | ...
    Computer Education
    • Education
    Other
    • Other video
    Tally
    • Tally ERP.9 Rules of D...
    Internet
    • internet
    Computer GK
    • GK
    Reasoning
    • Reasoning
    Airthmatics
    • Airthmetic

КОМЕНТАРІ • 37

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

    Very useful video Sir. It will help a lot. This is the video which I was searching for my project. God bless you Sir.

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

    Sirji apka har video betrin aur helpful retai.

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

    sir basic jo apne samjhaya bahut achese samjha, thanks,

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

    Thank you sir.
    Aapne bahut acche se sikhaya.

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

    Thanks sir

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

    Sir aap samjate bahut achha lekin sir practice ke liye file discretion me rakha karo pls sir

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

    Sir, it is very useful trick,thanxs

  • @parmanandshastri7718
    @parmanandshastri7718 10 місяців тому

    Your method is easy

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

    Nice

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

    Very nice class sir

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

    Thank u so much sir 😍

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

    Shukriya sir❤

  • @BrijeshKumar-ol3yx
    @BrijeshKumar-ol3yx 3 роки тому

    Sir it is very knowledgeable video

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

    very nice

  • @ROSEKAURA
    @ROSEKAURA 4 місяці тому

    Hi please help me in this excel formula.
    I have the data in excel. Column A and Column B. A1 = 1.5, a2=2, a3=2, a4=2.5, a5=3, a6=3. and comparing data in column b, b1=6203, b2=6203, c3=6204, c4=6205, c5=6205, c6=6206.
    now I need the validation list formula. If I type in cell L184=1.5 then in the list 6203 may appear as it is on a1 and on b1. if cell L184=2 then in the list 6203 and 6204 seperately show as the reference data is on a2, a3 and on b2, b3. if cell L184=2.5 then in the validation list 6205 may show as it is related with cell a4 and b4. if cell L184=3 then in the validation list may show 6205 and 6206 seperately as it is related with cell a5, a6 and b5, b5. please give me the formula for validation list.

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

    Excellent

  • @vinodkadam6410
    @vinodkadam6410 4 місяці тому

    Dear sir
    Open office me vlook up me #n/a aata hai usko remove karne ke liye konsa formula use kar sakte hai.
    Excel me to iferror use karte hai open office ka detail mil sakta hai kya.

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

    good

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

    Practise file bi share kiyatho bahuth acha

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

    Namsakar Sir vba for pay roll k liye video daliye for central govt employee with pay slips and pay bill for a particular month

  • @AsifHussain-ge4dy
    @AsifHussain-ge4dy Рік тому

    Sir plz help me to create a stock report for the inventory of raw materials of the plant just as sugar, performs, closer, interlayer sheet, concentrate, etc

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

    In sheet1 have raw material and in sheet2 finished goods, there are 3 items that use same material to assembled.
    What formula shall I use to deduct raw material in sheet1

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

      ua-cam.com/video/1ycerK8W7Ts/v-deo.html
      ua-cam.com/video/es2B-e7I2T4/v-deo.html

  • @AP-gr4ij
    @AP-gr4ij Рік тому

    Sir agar is sheet me koyi double name ho to uska kaise sum karen

  • @AP-gr4ij
    @AP-gr4ij Рік тому

    Agar item name double ho to uska kaise nukalu

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

    Sir Excel me multi sheet to sheet save image ki size kese badaye ek sath
    Jese ki sheet1 sheet 2ko ek sath select Kar ke image ki size kase badaye

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

      image ki size alag alag sheet me ek saath nahi badhegi kyonki wo excel ka part nahi hai image alag alag hi badhani hogi

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

    सर basic बता देते हैं लेकिन प्रॉब्लम भी solve करे.. Indirect function main two word k liye hyphen use karna padta hai,, ना करने पड़े कोई solution दो

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

    Nice

  • @manjit.sarania
    @manjit.sarania 2 роки тому

    Thank you sir