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

  Рет қаралды 21,011

Computer Gyan Guruji

Computer Gyan Guruji

Күн бұрын

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
@rosariocoutinho8690
@rosariocoutinho8690 Жыл бұрын
Sirji apka har video betrin aur helpful retai.
@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.
@rachitatiwari9064
@rachitatiwari9064 3 жыл бұрын
sir basic jo apne samjhaya bahut achese samjha, thanks,
@uditnarayanshukla8606
@uditnarayanshukla8606 2 жыл бұрын
Thanks sir
@dakshkumar873
@dakshkumar873 3 жыл бұрын
Thank you sir. Aapne bahut acche se sikhaya.
@kmanoj392
@kmanoj392 Жыл бұрын
Nice
@vinodkumargond6494
@vinodkumargond6494 3 жыл бұрын
Sir, it is very useful trick,thanxs
@kishorpanara4191
@kishorpanara4191 3 жыл бұрын
Sir aap samjate bahut achha lekin sir practice ke liye file discretion me rakha karo pls sir
@ComputerGyanGuruji
@ComputerGyanGuruji 3 жыл бұрын
link daal diya hai
@parmanandshastri7718
@parmanandshastri7718 10 ай бұрын
Your method is easy
@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
@ComputerGyanGuruji
@ComputerGyanGuruji 3 жыл бұрын
Keep watching
@ravichauhan3933
@ravichauhan3933 2 жыл бұрын
very nice
@gopalakrishnankrishnan7067
@gopalakrishnankrishnan7067 3 жыл бұрын
Excellent
@ComputerGyanGuruji
@ComputerGyanGuruji 3 жыл бұрын
Thank you so much 😀
@vinodkadam6410
@vinodkadam6410 5 ай бұрын
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.
@ROSEKAURA
@ROSEKAURA 5 ай бұрын
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.
@snsubratroutray
@snsubratroutray 3 жыл бұрын
good
@ComputerGyanGuruji
@ComputerGyanGuruji 3 жыл бұрын
Thanks
@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
@sreenivasnair3926
@sreenivasnair3926 3 жыл бұрын
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
@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 жыл бұрын
kzbin.info/www/bejne/Z6rGlqWBbbxqitU kzbin.info/www/bejne/m6SVc2CbbK5lipY
@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 दो
@ComputerGyanGuruji
@ComputerGyanGuruji Жыл бұрын
Noted
@sankalpshukla2192
@sankalpshukla2192 2 жыл бұрын
Nice
@manjit.sarania
@manjit.sarania 2 жыл бұрын
Thank you sir
Whoa
01:00
Justin Flom
Рет қаралды 57 МЛН
Magic or …? 😱 reveal video on profile 🫢
00:14
Andrey Grechka
Рет қаралды 67 МЛН
Фейковый воришка 😂
00:51
КАРЕНА МАКАРЕНА
Рет қаралды 6 МЛН
Nastya and balloon challenge
00:23
Nastya
Рет қаралды 25 МЛН
7 Ways to Use Vlookup in Excel
16:44
My E-Lesson
Рет қаралды 2,7 МЛН
Whoa
01:00
Justin Flom
Рет қаралды 57 МЛН