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
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..❤🙏
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.
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))
you are excellent in every field................. The knowledge you share is Outstanding............. You help me a lot .............Thanks a lot......... I didn't no basic concept of excel but you make me to outstanding in word, excel & powerpoint........ My only one request to make tutorials & series on Power BI.......... I am so interested in it and non of the videos make me to satify and full knowledge on it...........So i am request to you for clear vision on it............ Plz sir pick my comment..........
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 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.
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
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
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...
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
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
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 UA-cam pe bhaut kaam apke jesha teacher hai jo itne chote chote point smajte hai you are the best teacher❤❤❤❤❤
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
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
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
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
![vlookup in excel | 5 Types of vlookup | excel interview questions [Hindi] #vlookup](http://i.ytimg.com/vi/KJ8jFCsZB2Y/mqdefault.jpg)
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
U r such a hardworking teacher...salute ur efforts..excellent explanation
Really maza aa gya bhut sare doubts clear ho gye
Thanku
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............
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 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..❤🙏
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.
Bahot achchha laga sir ji
Thank You So Much... Never thought I would learn Vlookup so easily... Hats off to your dedication sir... ♥️
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))
Sir, your style of teaching is absolutely Genius and remarkable, it's so easily understandable.
you are excellent in every field.................
The knowledge you share is Outstanding.............
You help me a lot .............Thanks a lot.........
I didn't no basic concept of excel but you make me to outstanding in word, excel & powerpoint........
My only one request to make tutorials & series on Power BI..........
I am so interested in it and non of the videos make me to satify and full knowledge on it...........So i am request to you for clear vision on it............
Plz sir pick my comment..........
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
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 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.
After watching this entire video and practicing it, I would just like to say sir you are a gem 💎❤️
Ii
Ii
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 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
Sir I am CA Inter clear currently doing Articleship and your videos are very helpful for me during Audit.
God bless you Sir
This is the type of teaching
Exellent Satish sir.. Thank s for your work & systematic way to provides valuable knowledge @learnmore
Sir sachme . Dusre youtube channels me aisa detail and complete explainations nahi hai. .. nicely explained.
Thank you sir ...Thank you so much , i can't explain how much I wanted the topic...❤️
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
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.ua-cam.com/video/5n4vaY8XjrE/v-deo.html
FANTASTIC, VERY NICE TEACHING TECHNIC SIR....... KEEP IT UP
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.
best video ever on VLOOKUP.....We appreciate your efforts 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
You are the one whom I search for whenever I need to learn any topic of computer.
thank you u r the best
The work of teaching so great l love it your great and you are genies
Thanks iIqbal bhai
I genuinely think apne tin ghante tak banaya aur maine constantly dekha thankful
Amazing video. No words to define your heard work 🙃
Sir is vedio me aapka efforts clear dikh raha hai.. Most powerful and useful vedio
Really sir, u are very hard working. Thx sir, for sharing such a useful knowledge and for making such a detailed video for us.
Best video to learn vlookup from basic to advance ..very helpful for me.
Thank you
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
Best teacher I have ever saw on youtube
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 ??
Very Very Help for me i will going to go for interview, I was saw this video. Very helpful. Thank you sir !!!
I think you are the only teacher on UA-cam, who teaches with all the nitty-gritty. Thanks a lot. Doing Great Job 💯👌
Sir hlookup par Master video banaye
You are best teacher for computer knowledge in the world
SIR MAKE VIDEO ON MS ACCESS 2019
BECAUSE ONLY LIMITED VIDOES ARE THERE ON UA-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
Sir Jo samjhaya bhot achhe se aaya. Best video for Excel learning. Thanks Sir.
❤️
Great Sir ... You did an excellent job... I am from Pakistan and I am a big fan of yours ....
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
बहुत सुन्दर माँ भगवती करे आप इसी तरह लोगों की परेशानी दूर करें और आप का ज्ञान अथाह बढ़ता रहे
Awesome video sir...hats off👍👍👍🙏🙏
bht sahi hai aapka chnel
or Ms office pura sikhne or revisiin krne ko mila hai.
Aap bahut achhe se explain karte hai sir thanks for the video.
You are amazing Sir
U have solved all my mystery.
Thanks alot 🙏🙏
Among all tutorial this real tutorial(learn more) is the best tutorial in the UA-cam channel.
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 UA-cam pe bhaut kaam apke jesha teacher hai jo itne chote chote point smajte hai you are the best teacher❤❤❤❤❤
Beautiful explanation and the best part is you explain each and every details in hindi.
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
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
You are the best sir, I refer this video to all my friends .👍👍
Very helpful sir ❤❤❤❤
Sir, aap ne bahut badhiya tarike se vlookup ke bare me samzaya hai. Muze ye kafi helpful rahega. Thank you sir.
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
Certainly, I have become your fan, Great teaching sir !
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
Top video hai sir katai ...Bemisal ...Gjv ....Faadu .... superb 😊❤
Many thanks Sir Deepak
You have done a great job 💯💯💯💯
Thanks for teaching vlookup with full details ❤
aap bohot he details me batate ho. itna details koi nahi batata. mai ne aap se boht kuch sikha hai. thank you so much
Your teaching style is incredible, everything is explained beautifully
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
Bahut bahut dhanyawad sir apne aaj sare doubt clear kar diye Vlookup ke ...bahut bahut dhanyawad sir ji
Love the way you explain things sir... love and respect from swat Pakistan...💖💖💖💖
Best Excel tutorial video i ever watched
Amazing content sir.. I learnt more from your video.. Thank you
Yes yes you are amazing 🙏🙏 god bless you 🙏 sir..thanx .am always follow you
Contents agar Genuine ho to koi farq nahi parta k video kitni vi lambi q na ho. I always appreciate your hard work Sir.
You are too good Sir
You are the master mind of vlookup in excel.
धन्य है गुरु देव आप को ।
Really sir you are great....
It Itna mehenat karte ho.ek ek video.mein.salut sir...🙏
One of the more useful video, Thanks for bringing into public
GREAT TEACHER
I'm sure sir aapki video dekhi bhi nhi h or all subscribe kr liya aapki video or like or comment bhi 🎉🎉👏👏👏👏👏
Great Man. Appreciated. Thanks for wonderful videos
I have never seen a person who explain in such a beautiful way......🙏
You are such an amazing teacher. You are so knowledgeable & hardworking. l learn alot of your videos.
sir ur teaching style is very simple and impressive.
salam from pakistan
Excellent Teaching way, Amazing, & Very important Vedio..
thank you sir aap ki video dekh kar mujhe bahut kuch sikne ko milta hai, so thank you so much sir
Thanks sir u are a real teacher
Really u r great sir no one can teach like you
Ur teaching is fantastic sir. I always watch ur video and learn many things.
Amazing teaching way appreciate you to teach us important excel formula . thank you so much .
Dear sir,
All the tricks & the way of explanation is amazing 😍
Thanking you so much 😁
Sir, your excel tutorial are best on youtube channel
Sir, nice video. I like your all video. I always learn from your videos. And your explanation is very nice.
Excellent sir, the way you are teching is very helpful for all of those who don't have any technical background.
Really grateful video 🥰 thank you so much sir for this efforts keep it up.. ✨❤️
Very helpful video to those people who want to be master in Vlookup.
This is a One of the best vlookup video
Best concept, the way of teaching and your example are awesome sir