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

Vlookup with Indirect Function in Excel Hindi | Use INDIRECT to Reference sheets within VLOOKUP.
#vlookupinexcel #indirectinexcel #computergyanguruji
Practice file download - drive.google.com/file/d/1LA_R...
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

  • @rosariocoutinho8690
    @rosariocoutinho8690 Жыл бұрын

    Sirji apka har video betrin aur helpful retai.

  • @rachitatiwari9064
    @rachitatiwari90643 жыл бұрын

    sir basic jo apne samjhaya bahut achese samjha, thanks,

  • @dakshkumar873
    @dakshkumar8733 жыл бұрын

    Thank you sir. Aapne bahut acche se sikhaya.

  • @sanjitpaul2953
    @sanjitpaul29533 жыл бұрын

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

  • @uditnarayanshukla8606
    @uditnarayanshukla8606 Жыл бұрын

    Thanks sir

  • @vinodkumargond6494
    @vinodkumargond64943 жыл бұрын

    Sir, it is very useful trick,thanxs

  • @parmanandshastri7718
    @parmanandshastri77189 ай бұрын

    Your method is easy

  • @BrijeshKumar-ol3yx
    @BrijeshKumar-ol3yx3 жыл бұрын

    Sir it is very knowledgeable video

  • @ComputerGyanGuruji

    @ComputerGyanGuruji

    3 жыл бұрын

    Keep watching

  • @umeshray3463
    @umeshray34632 жыл бұрын

    Very nice class sir

  • @sohibqureshi7615
    @sohibqureshi7615 Жыл бұрын

    Shukriya sir❤

  • @Altaf_Alam
    @Altaf_Alam2 жыл бұрын

    Thank u so much sir 😍

  • @kmanoj392
    @kmanoj392 Жыл бұрын

    Nice

  • @ravichauhan3933
    @ravichauhan39332 жыл бұрын

    very nice

  • @snsubratroutray
    @snsubratroutray3 жыл бұрын

    good

  • @ComputerGyanGuruji

    @ComputerGyanGuruji

    3 жыл бұрын

    Thanks

  • @kishorpanara4191
    @kishorpanara41913 жыл бұрын

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

  • @ComputerGyanGuruji

    @ComputerGyanGuruji

    3 жыл бұрын

    link daal diya hai

  • @gopalakrishnankrishnan7067
    @gopalakrishnankrishnan70673 жыл бұрын

    Excellent

  • @ComputerGyanGuruji

    @ComputerGyanGuruji

    3 жыл бұрын

    Thank you so much 😀

  • @sreenivasnair3926
    @sreenivasnair39263 жыл бұрын

    Practise file bi share kiyatho bahuth acha

  • @ComputerGyanGuruji

    @ComputerGyanGuruji

    3 жыл бұрын

    link daal diya hai

  • @sreenivasnair3926

    @sreenivasnair3926

    3 жыл бұрын

    @@ComputerGyanGuruji thank you so much,best wishes from kerala

  • @rohankumar025
    @rohankumar0253 жыл бұрын

    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

  • @ROSEKAURA
    @ROSEKAURA3 ай бұрын

    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.

  • @vinodkadam6410
    @vinodkadam64103 ай бұрын

    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.

  • @qamruddinmohammedi7665
    @qamruddinmohammedi76653 жыл бұрын

    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 жыл бұрын

    kzread.info/dash/bejne/Y62Xx9SEaLqdhNY.html kzread.info/dash/bejne/l6dmpI-eZ6yYhJc.html

  • @AP-gr4ij
    @AP-gr4ij Жыл бұрын

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

  • @brijeshgurjar2068
    @brijeshgurjar20683 жыл бұрын

    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

  • @AP-gr4ij
    @AP-gr4ij Жыл бұрын

    Agar item name double ho to uska kaise nukalu

  • @pankajknowledgeworld
    @pankajknowledgeworld Жыл бұрын

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

  • @ComputerGyanGuruji

    @ComputerGyanGuruji

    Жыл бұрын

    Noted

  • @sankalpshukla2192
    @sankalpshukla2192 Жыл бұрын

    Nice

  • @manjit.sarania
    @manjit.sarania Жыл бұрын

    Thank you sir