Mein jhut nhi bolungi...pure din job vacancy dekhne ke baad ...mein Excel kese sikhun yeh soch rhi thi... Raat mein 1 bje meine apna laptop uthaya aur youtube pe Search kia mujhe aapka video mila basic excel for beginners ke liye... Jesa jesa video mein dekha vese vese kiya meine one hour mein almost basic sikhh liya... Thankyou so so much...uss one hour mein mujhe excel kya hota hai aur kese work hota hai short keys ki helps se... I really wanted to appreciate you for your videos ,that's really helps those who scared to join classes or may be they can't afford.. 😊
There are very few teachers who teach with the passion of teaching and not rushing, but break the theory down with explanation. i am very happy to found your channel and learn easily and on my own slow pace. I always felt dumb about not being able to learn anything on excel out of fear of logics and number but the best part abt you is that you break the logic
Unbelievable...the effort you have put in this video....not only explaining what things are happening, But also WHY those things are happening, logics behind everything. Thank you so much for this sir.
Sir you are great aap hi ho jo hm students ko technology ka shi gyan de rhe ho nhi to bahut se nausikhiye coaching khol kr baith gye h sir main Adca krna chahta hu aap krwaoge
I have thoroughly gone through your full video. Learn lots of functions & formulas which I never used so far for monthly reporting purpose. Now I can prepare my reports with using Vlookup formulas along with multi functions. Great video I ever seen. Thanks again for free videos...... bye for now.Chirag dalal
Apki saari videos dekh k boht kuch sikhte hai aur main baat bilkul bhi bore ni hote itni interesting tarike se aap padhate ho ... Respect for you sir... God bless you
I have learn within 30 minutes Since few days I could not use Vlookup formula, I learned it by practicing with you.... I am going to apply job for MIS Executive..❤🙏
I must congratulate you sir. your way of teaching was so good that I could perform Pivot table at work place and confidently I can do it. Thanks Sir. Also they way you present and start video like you are teaching face to face is commendable.
MULTI TABLE VLOOKUP mai ye formula lagaya hai sir apke teaching k baad khud se...thank you for giving us so appropriate knowledge =IFERROR(IFERROR(VLOOKUP($F$17,LIST12,ROW()-16,0),VLOOKUP($F$17,LIST13,ROW()-16,0)),VLOOKUP($F$17,LIST14,ROW()-16,0))
Unbelievable, I don't have a word to say you thank you, I had taken training of advance excel and currently I have forgotten everything because they had never trained us that much deeply. Thank you Once again Sir god bless you!
Sir, I enjoy your freestyle of teaching with funny background sounds and comments that are very enjoyable while learning Excel. Keep up your sense of humor while we learn great lessons from you.
Sir you are great👍 I just want to give one suggestion that in your interview question sheet...If you are apply the vlookup or any other formula in blank/any other data using filter...Then select the blank/any data where you want to apply the formula and apply Alt + ;...it helps to apply the formula only the blank values...Not in whole data... Because it sometimes happen in huge data the formula can be apply in another cell also where you don't want to apply the formula...
Sir Thank you so much. bahut acche se ek ek chiz sikhai aapne mujhe bahut kuch malum tha par wapas se sikha aur jo pehle se ata tha wo bhi sikhne me borring nahi hui. thank you once again
Before this video, I watched a video of 5 hours duration which was a full Excel tutorial. after watching this video for only 20 mins I am feeling sad for myself why shouldn't I land on this tutorial before. This is amazing just in 20 mins I understood these 3 hours of Vlook Up tutorials gonna be worth it. thanks, man.
App bhaut ache se samjhte hai apki teaching style ache se smjh aate hai TH-cam pe bhaut kaam apke jesha teacher hai jo itne chote chote point smajte hai you are the best teacher❤❤❤❤❤
Ham Kisi shop par full time job Karte Hain balance sheet final karne ke liye 31st March ko Hamen kaun kaun si entry karni padegi plz. Is topic per ek video banaaiye
sir ap bahut awsssm hai ham jaise logo ki bahut sari help karte hai jinke paas jada money nahi sikhne k liye par ap jaise kuch ache log ham jaiso k liye asan kar dte hai sikhna jine sikhna to hai par sikhne k liye paise mhi hote
Hi sir, first of all I would like to appreciate and pay thanks for making such easy and informative lecture on vlookup. Sir my question is if in multi table vlookup the lookup value contains bith alphabetical and numerical characters, what if condition we gonna apply ??
Hello Sir , mai apka bahut bada Fan hu kal hi apka google steadsheet wala course complete kiya hai .. aj vlookup start kar rha hu .. video sroo hote hi bahut hassi aa rhi hai ajto ap pura parwachan wale pose me lag rhe hai......ha ha ha ha aaaaaa
I was the beginner and did not knew anything about VLOOKUP. Now i have learnt very well. You have many students from Pakistan including me. God bless you
GREAT EXPLANTION OF VLOOKUP WITH EASY EXAMPLES WHICH HELPS ME LOT, SINCE 1995 I AM USING EXCEL BUT KNOW I GOT KNOW THIS FUNCTION, TILL THIS TIME I AM USING NESTED IF, THANKS KEEP IT UP
BHAI SAHAB AAP BAHUT HI ACHHA SAMJHATE HAI LEKINE ITNA JYADA SIKHNE KE BADD MERA SAR GHUMNE LAGTA HA MERE WAS VLOOKUP WAS FIRST WALA HI SAMJHNE KE LIYE KAFI HA, I DONT HAVE SO MUCH MY MIND TO UNDERSTAND ALL OTHER
Really Superb complete course with practice data. As most of the channels doensn't provide to practice so there was no use to learn from that channel. But you have made this video awesome and practice data provides booster to the video. Thanks
![vlookup in excel | 5 Types of vlookup | excel interview questions [Hindi] #vlookup](/img/n.gif)
Attend Satish sir's Online Webinar Free: courses.skillcourse.in/webinars/
from where we can find thw worksheet u r working on ???
Sir muje HTML course karna hai
All course karna hai sir
Super sir
@@tdxrider9052 qAaa2aqaaqqqqqqqaaaqaaaaaqaq2a2aa2aa22q2aqa2qqaqaaAa2AQaaa2aa2aaa2qqaqqA2aqaaaaaaaqqqqaqqaqaaaaaqaqaaqa2qa2a2a2a22a2aa2q2qa2qa2q2aaa22AAaaq2AaaaaaaAaaaaaaaaqqaqqqqaqaaaqaaqaqaqaaaaqaaaa22222222a2aaaqAa2aqqqaqaqaa
Mein jhut nhi bolungi...pure din job vacancy dekhne ke baad ...mein Excel kese sikhun yeh soch rhi thi... Raat mein 1 bje meine apna laptop uthaya aur youtube pe Search kia mujhe aapka video mila basic excel for beginners ke liye... Jesa jesa video mein dekha vese vese kiya meine one hour mein almost basic sikhh liya... Thankyou so so much...uss one hour mein mujhe excel kya hota hai aur kese work hota hai short keys ki helps se... I really wanted to appreciate you for your videos ,that's really helps those who scared to join classes or may be they can't afford.. 😊
Congratulations 😂
Same here mujhe bhi bohot help mili aur easily Sikh liya.thankyu
What are you doing nowadays 😊
Khi job lgi tumhari?
😅😊😅😊😅😊😊 1:14:14 😅😊😊😊😊
There are very few teachers who teach with the passion of teaching and not rushing, but break the theory down with explanation. i am very happy to found your channel and learn easily and on my own slow pace. I always felt dumb about not being able to learn anything on excel out of fear of logics and number but the best part abt you is that you break the logic
you are right bro............
Bahot achchha laga sir ji
U r such a hardworking teacher...salute ur efforts..excellent explanation
Really maza aa gya bhut sare doubts clear ho gye
Thanku
5:21 - Vlookup introduction
46:55 - Range Lookup
58:42 - IF ERROR in Vlookup
1:04:34 - Nested Vlookup
1:14:39 - Filter in Vlookup
1:28:09 - Double Vlookup
1:44:35 - Multi table Vlookup
1:50:29 - Multi sheet and workbook vlookup
2:04:33 - Reverse Vlookup
2:22:24 - Vlookup + Match
2:30:30 - FIND + Vlookup
2:43:04 - 2 lookup values
2:47:45 - Vlookup queries
2:58:12 - MIS using Vlookup
Description me h bhai😅
You also did a Great Job Dear
Nice
Bhaiyya Iska PDF kaise download kre
@@smrutiranjanparida9766 Thankyou
I genuinely think apne tin ghante tak banaya aur maine constantly dekha thankful
Unbelievable...the effort you have put in this video....not only explaining what things are happening, But also WHY those things are happening, logics behind everything. Thank you so much for this sir.
Sir you are great aap hi ho jo hm students ko technology ka shi gyan de rhe ho nhi to bahut se nausikhiye coaching khol kr baith gye h sir main Adca krna chahta hu aap krwaoge
I have thoroughly gone through your full video. Learn lots of functions & formulas which I never used so far for monthly reporting purpose. Now I can prepare my reports with using Vlookup formulas along with multi functions. Great video I ever seen. Thanks again for free videos...... bye for now.Chirag dalal
Apki saari videos dekh k boht kuch sikhte hai aur main baat bilkul bhi bore ni hote itni interesting tarike se aap padhate ho ... Respect for you sir... God bless you
Sir, your style of teaching is absolutely Genius and remarkable, it's so easily understandable.
बहुत सुन्दर माँ भगवती करे आप इसी तरह लोगों की परेशानी दूर करें और आप का ज्ञान अथाह बढ़ता रहे
After watching this entire video and practicing it, I would just like to say sir you are a gem 💎❤️
Ii
Ii
Aap bahut achhe se explain karte hai sir thanks for the video.
Thank You So Much... Never thought I would learn Vlookup so easily... Hats off to your dedication sir... ♥️
I have learn within 30 minutes Since few days I could not use Vlookup formula, I learned it by practicing with you.... I am going to apply job for MIS Executive..❤🙏
The way of your teaching is really cool and funny sir, anyone can understand it very well, I have started to see you excel video just before 1 week
Guruji bahut sahi video hai aapka, bina kisi tension ke bahut aaram se explain kia hai aapne, new comers ke liye bahut beneficial hai
I must congratulate you sir. your way of teaching was so good that I could perform Pivot table at work place and confidently I can do it. Thanks Sir. Also they way you present and start video like you are teaching face to face is commendable.
MULTI TABLE VLOOKUP mai ye formula lagaya hai sir apke teaching k baad khud se...thank you for giving us so appropriate knowledge =IFERROR(IFERROR(VLOOKUP($F$17,LIST12,ROW()-16,0),VLOOKUP($F$17,LIST13,ROW()-16,0)),VLOOKUP($F$17,LIST14,ROW()-16,0))
Thank you sir ...Thank you so much , i can't explain how much I wanted the topic...❤️
Really sir jab se Maine video dekhna start Kiya hai
Mai apka biggest fan ban Gaya hunn🥰🥰
This is the type of teaching
Exellent Satish sir.. Thank s for your work & systematic way to provides valuable knowledge @learnmore
Unbelievable, I don't have a word to say you thank you, I had taken training of advance excel and currently I have forgotten everything because they had never trained us that much deeply. Thank you Once again Sir god bless you!
Dear Raju,you can also
visit our channel for more videos.th-cam.com/video/5n4vaY8XjrE/w-d-xo.html
aap bohot he details me batate ho. itna details koi nahi batata. mai ne aap se boht kuch sikha hai. thank you so much
Sir, I enjoy your freestyle of teaching with funny background sounds and comments that are very enjoyable while learning Excel. Keep up your sense of humor while we learn great lessons from you.
Sir Jo samjhaya bhot achhe se aaya. Best video for Excel learning. Thanks Sir.
Sir you are great👍
I just want to give one suggestion that in your interview question sheet...If you are apply the vlookup or any other formula in blank/any other data using filter...Then select the blank/any data where you want to apply the formula and apply Alt + ;...it helps to apply the formula only the blank values...Not in whole data... Because it sometimes happen in huge data the formula can be apply in another cell also where you don't want to apply the formula...
Great! this is also the solution pranita ji.
Mis Second method Goto special Visible Cell Only Than Vlookup
Sir Thank you so much.
bahut acche se ek ek chiz sikhai aapne
mujhe bahut kuch malum tha par wapas se sikha aur jo pehle se ata tha wo bhi sikhne me borring nahi hui.
thank you once again
Before this video, I watched a video of 5 hours duration which was a full Excel tutorial. after watching this video for only 20 mins I am feeling sad for myself why shouldn't I land on this tutorial before. This is amazing just in 20 mins I understood these 3 hours of Vlook Up tutorials gonna be worth it. thanks, man.
❤
Amazing video. No words to define your heard work 🙃
App bhaut ache se samjhte hai apki teaching style ache se smjh aate hai TH-cam pe bhaut kaam apke jesha teacher hai jo itne chote chote point smajte hai you are the best teacher❤❤❤❤❤
Really sir, u are very hard working. Thx sir, for sharing such a useful knowledge and for making such a detailed video for us.
धन्य है गुरु देव आप को ।
The work of teaching so great l love it your great and you are genies
Thanks iIqbal bhai
Aapke batane ka jo andaj h bahut hi achha h sir or samjhhane ka tarika vo to zero ko bhi hero bana dega. thank you sir
Ham Kisi shop par full time job Karte Hain balance sheet final karne ke liye 31st March ko Hamen kaun kaun si entry karni padegi plz. Is topic per ek video banaaiye
sir ap bahut awsssm hai ham jaise logo ki bahut sari help karte hai jinke paas jada money nahi sikhne k liye par ap jaise kuch ache log ham jaiso k liye asan kar dte hai sikhna jine sikhna to hai par sikhne k liye paise mhi hote
Sir hlookup par Master video banaye
Duniya ka sbse achha teacher 🫡
Hi sir, first of all I would like to appreciate and pay thanks for making such easy and informative lecture on vlookup.
Sir my question is if in multi table vlookup the lookup value contains bith alphabetical and numerical characters, what if condition we gonna apply ??
Ap itana acche sa padhate hai jisa ki apko sari jankari detail ma pata ho
❤️
I have never seen a person who explain in such a beautiful way......🙏
SIR MAKE VIDEO ON MS ACCESS 2019
BECAUSE ONLY LIMITED VIDOES ARE THERE ON TH-cam
Really...??
How many videos are there
I also want to busy
Is it useful or not...?
Yes sir ms access pr bi bnae video complete tutorial
bht sahi hai aapka chnel
or Ms office pura sikhne or revisiin krne ko mila hai.
Hello Sir , mai apka bahut bada Fan hu kal hi apka google steadsheet wala course complete kiya hai ..
aj vlookup start kar rha hu ..
video sroo hote hi bahut hassi aa rhi hai
ajto ap pura parwachan wale pose me lag rhe hai......ha ha ha ha aaaaaa
Sir is vedio me aapka efforts clear dikh raha hai.. Most powerful and useful vedio
Bahut bahut dhanyawad sir apne aaj sare doubt clear kar diye Vlookup ke ...bahut bahut dhanyawad sir ji
Sir I am CA Inter clear currently doing Articleship and your videos are very helpful for me during Audit.
God bless you Sir
Contents agar Genuine ho to koi farq nahi parta k video kitni vi lambi q na ho. I always appreciate your hard work Sir.
Aap jaise teacher mil jaye to kuchh bhi impossible nhi h
Vikas खतरनाक hai sir 👍👍👍👍
Sir, aap ne bahut badhiya tarike se vlookup ke bare me samzaya hai. Muze ye kafi helpful rahega. Thank you sir.
Best teacher I have ever saw on youtube
Sir sachme . Dusre youtube channels me aisa detail and complete explainations nahi hai. .. nicely explained.
aapke video bahoot acche hai jaldi samjh jate hai our bore nahi hota hai
app ke jesa koi nhi padata he sir
I was the beginner and did not knew anything about VLOOKUP. Now i have learnt very well. You have many students from Pakistan including me. God bless you
You are the one whom I search for whenever I need to learn any topic of computer.
thank you u r the best
GREAT EXPLANTION OF VLOOKUP WITH EASY EXAMPLES WHICH HELPS ME LOT, SINCE 1995 I AM USING EXCEL BUT KNOW I GOT KNOW THIS FUNCTION, TILL THIS TIME I AM USING NESTED IF, THANKS KEEP IT UP
Thank you sir aap bahut hi achhe se samjhate hain ki aasani se samjh me aata hai🙏
You are best teacher for computer knowledge in the world
I think you are the only teacher on TH-cam, who teaches with all the nitty-gritty. Thanks a lot. Doing Great Job 💯👌
AAP KI SARI VEDIO BEST SE BHI BEST HAI
BHAI SAHAB AAP BAHUT HI ACHHA SAMJHATE HAI LEKINE ITNA JYADA SIKHNE KE BADD MERA SAR GHUMNE LAGTA HA MERE WAS VLOOKUP WAS FIRST WALA HI SAMJHNE KE LIYE KAFI HA, I DONT HAVE SO MUCH MY MIND TO UNDERSTAND ALL OTHER
काफी ज्ञानवर्धक रहा
GREAT TEACHER
You are too good Sir
I'm sure sir aapki video dekhi bhi nhi h or all subscribe kr liya aapki video or like or comment bhi 🎉🎉👏👏👏👏👏
FANTASTIC, VERY NICE TEACHING TECHNIC SIR....... KEEP IT UP
Among all tutorial this real tutorial(learn more) is the best tutorial in the TH-cam channel.
Super thanku Sir
bhai thank u so much mai apke saare video dekhta hu bahot detail me hota hai thanks
You are the master mind of vlookup in excel.
best video ever on VLOOKUP.....We appreciate your efforts sir....👍
Jitna bole sir apko kam hai no 1 technique and knowledge
Really Superb complete course with practice data. As most of the channels doensn't provide to practice so there was no use to learn from that channel. But you have made this video awesome and practice data provides booster to the video. Thanks
Thank you sir aap bahut achchha samjhate hai
Thanks sir vlookup ko bariki se explain Karne ke liye
Sir ap students ki bahot help karte ho
Thanks a lot sir
Bahut acha samjhate hai sir.Thank you so much.
Thanks sir u are a real teacher
Sir aap bade hi prem se batate hai
Guru ji pranam 🙏 bahut acche se padhate ho aap . Bhaukaal bulkul bhi nahi hai sab asli maal hai aapke video me 🙏👌
Waao.. Shaandar, Jabardast..
Really sir you are great....
It Itna mehenat karte ho.ek ek video.mein.salut sir...🙏
AAP ki baje she hame bahot kuchh shikhane ko mila sir
Top video hai sir katai ...Bemisal ...Gjv ....Faadu .... superb 😊❤
Sir aapka video bahot achcha hai easily samaj me aata hai
Beautiful explanation and the best part is you explain each and every details in hindi.
Best Excel tutorial video i ever watched
Sir ji aap kammal ho sabse best teacher ho aap aur deepak sir from eduworl computer ke mera future to bas aap dono mein depend hain
Very helpful sir ❤❤❤❤
Best video to learn vlookup from basic to advance ..very helpful for me.
Thank you
Sir aap behut acha pedhate hai
Thank you sir
zindagi me aise guru mil jaye to maza hi ya jaye zindagi ka..
Very helpful video to those people who want to be master in Vlookup.
you are just like god to us, because of you so many people will become skillful. Thank you sir.