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

แชร์
ฝัง
  • เผยแพร่เมื่อ 20 ต.ค. 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

  • @rachitatiwari9064
    @rachitatiwari9064 3 ปีที่แล้ว

    sir basic jo apne samjhaya bahut achese samjha, thanks,

  • @rosariocoutinho8690
    @rosariocoutinho8690 ปีที่แล้ว

    Sirji apka har video betrin aur helpful retai.

  • @dakshkumar873
    @dakshkumar873 3 ปีที่แล้ว

    Thank you sir.
    Aapne bahut acche se sikhaya.

  • @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.

  • @manjit.sarania
    @manjit.sarania 2 ปีที่แล้ว

    Thank you sir

  • @umeshray3463
    @umeshray3463 2 ปีที่แล้ว

    Very nice class sir

  • @ravichauhan3933
    @ravichauhan3933 2 ปีที่แล้ว

    very nice

  • @vinodkumargond6494
    @vinodkumargond6494 3 ปีที่แล้ว

    Sir, it is very useful trick,thanxs

  • @parmanandshastri7718
    @parmanandshastri7718 ปีที่แล้ว

    Your method is easy

  • @sohibqureshi7615
    @sohibqureshi7615 2 ปีที่แล้ว

    Shukriya sir❤

  • @kmanoj392
    @kmanoj392 2 ปีที่แล้ว

    Nice

  • @Altaf_Alam
    @Altaf_Alam 2 ปีที่แล้ว

    Thank u so much sir 😍

  • @BrijeshKumar-ol3yx
    @BrijeshKumar-ol3yx 3 ปีที่แล้ว

    Sir it is very knowledgeable video

  • @ROSEKAURA
    @ROSEKAURA 6 หลายเดือนก่อน

    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.

  • @sreenivasnair3926
    @sreenivasnair3926 3 ปีที่แล้ว

    Practise file bi share kiyatho bahuth acha

  • @kishorpanara4191
    @kishorpanara4191 3 ปีที่แล้ว +1

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

  • @gopalakrishnankrishnan7067
    @gopalakrishnankrishnan7067 3 ปีที่แล้ว

    Excellent

  • @snsubratroutray
    @snsubratroutray 3 ปีที่แล้ว

    good

  • @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

  • @vinodkadam6410
    @vinodkadam6410 6 หลายเดือนก่อน

    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.

  • @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

  • @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 ปีที่แล้ว

      th-cam.com/video/1ycerK8W7Ts/w-d-xo.html
      th-cam.com/video/es2B-e7I2T4/w-d-xo.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 2 ปีที่แล้ว

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

  • @uditnarayanshukla8606
    @uditnarayanshukla8606 2 ปีที่แล้ว

    Thanks sir

  • @sankalpshukla2192
    @sankalpshukla2192 2 ปีที่แล้ว

    Nice