VLookup in Excel Part 1 | VLOOKUP सिर्फ़ 30 minute में (हिंदी) Excel Lecture 4 | Neeraj Arora
Вставка
- Опубліковано 13 гру 2019
- #vlookup #ExcelforBeginners #neerajarora
Hi Guys! In this video, we will learn about VLOOKUP in Excel. VLOOKUP is one of the most important toosl in ms excel. In this video I have talked about how to use vlookup in ms excel and in addition to this we will also learn how to effectively use the vlookup formula. This vlookup tutorial is really going to increase your performance in work. Also, If you are about to appear in an interview and your job requires the use of excel, there are big chances that they may ask VLOOKUP formula.
In this video, we have discussed the following topics.
VLOOKUP definition
VLOOKUP Formula
VLOOKUP Examples
VLOOKUP basic case
VLOOKUP advance case
VLOOKUP Errors
VLOOKUP Approx Match
VLOOKUP Exact Match
VLOOKUP Intersheet
VLOOKUP Misc Topics
इस विडीओ में हमने VLOOKUP को काफ़ी डिटेल में कवर किया है उमीद करता हूँ आपको पसंद आएगी !
=========
🔥 Learn & Master Excel With 3500+ Students Across India on Excel Club 🔥
Link: www.skill91.com/s/store/cours...
😍 Why Choose Excel Club By Neeraj Arora ? 😍
✅ 50+ Detailed pre-recorded videos highlighting every feature & function of Excel.
✅ Access anytime & anywhere On Android, iOS, and Web. Breathe easy and download videos on the fly to enjoy remote access
✅ 350+ Multiple Choice Based Tests to track your progress & evaluate your current level of proficiency with excel
✅ Interviews with Corporate Professionals from World’s Leading Organizations - uncover their experience with Excel & how they use Excel in their daily work to make real-time business decisions.
✅ Real-life use cases of excel that you can use in your job, business, or internship
✅ Certificate from Skill91 that you can highlight in your resume
✅ And above all a 24x7 Discussion Forum where you can ask all your doubts for an unlimited number of times and get personalized responses in a community of more than 3500 students who are learning excel with you RIGHT NOW!
Wondering about validity?
Don't worry. Each enrollment is valid for a SOLID 365 days!
No matter if you're a student, professional, or just looking to get started on MS-Excel
Excel Club will prove to be an EXCELLENT choice for mastering MS-Excel in a unique, fun, engaging, and informative way.
All Prices Running On Discounted Prices. Limited Time Offer Expires Soon.
🔥 Learn & Master Excel With 3500+ Students Across India on Excel Club 🔥
Link: www.skill91.com/s/store/courses/description/Excel-Club
I am in Dubai, I can't join excel club, indian number not working here so I added dubai number, now 4 digit code not received, what is the solution
@@MWAIslamicStudio arasS sa ddzx*Xx Dd
Salute you sir, i know V lookup but your teaching skill is excellent with depth knowledge
Ek video pivot table pe b dekhna chahunga sir🤗
Kahan se khoju vlookup
video starts from 03:84, thank me later.....
Thankyou
03:48 aactually
Thanks 😂
Me watching ur comment after watching full video 😢
@@rutvikjani5154😅
Sir, most of the time people make jokes on this but today you proved that this line is not a joke and make this a reality that "sirf naam hi kaafi hai". whole CA family trust u to that extent that as this channel is of Neeraj sir then every video is worth to watch and every time u give more then the expectations. Thank u so much sir.. Respect for u always from heart..!
Thank you. Sir❤️
S
Very helpful , everytime interviewer ask me about vlookup and i alwyz said that i dont know how to use.. but now i can say yes i know what is vlookup and how to use it.
Thank you
Extremely nice explanation. It cleared all of my doubts..
Thank you very much for his wonderful contribution in society !
Easy to Learn, Easy to Understand and Fun while learning, keep going Sir, thank you.
Finally is vedio ko dekh kr seriously samjh m aya vlookup itna asan h.....this is it
Yes.. same here
Jitna in sir ka padhane ka style acha hai itna to tution mei achi fees dene k bad bhi koi nahi batata hai. hats of you and your education skills sir.
Thank you so much sir...your classes are helping me a lot to learn excel in the proper way and gain some confidence🙏
it was really helpful to understand the concept. I tried practical use of it and without any mistake I separated some data from large data file.
I had learnt VLOOKUP 2-3 days back.... But saw your full vedio because i knew I will learn something more and GUESS WHAT.. i learnt it and that was APPROX MATCH...
I have watched many videos for vlookup formula. I saw many videos but I can say this was the best video I found on youtube. Thank you so much sir for this amazing video of lookup for formula. I can easily now use vlookup formula.
sir aapka tarika shandar h . me kabhi kisi video pr comment nhi krta pr is video ne comment krne pr majbur kr diya h ... i salute you
The way of u teaching us , its really very interesting and easy to learn 👏
awesome explanation. till now i was always afraid of vlookup, but now you have made it so simple . Thanks a billion...
Aaji L mere content real content to ye Hain sir there so many teachers who teaching VLookup but but no one teaching like you your teaching like elder brother (Jo Puri imandari k Saath sikhta h) thanks a lot for giving such solid content.💜
Superb! Awesome!. I understood vlookup from you. I have checked other videos also. But your way of explaining and understanding that we are bigineers was outstanding. But aap ye excel share karte to aur maza aa jata
The way of teaching vlookup is far better than other videos which I had seen. Really did good job here. I have finally understood the proper use of Vlookup Sir ji. Thankyou for making this video for us. 😀
Thank you sir. This video made me v confident about v lookup function otherwise which I was dreadful about it over years. Thank you Sir🙌🏻. God Bless You.
awesome class sir alot of people around me told that working on excel is so much tough but when I start learning it from you I lov it :)
What a teacher🔥 i love the way you teach us🤗
Much awaited video of the whole excel series!!! Thank you so much sir!❤️
More to come. Thanks. Please share with all.
It's a biggest co incedent is my husband name is CA Neeraj katoch unhone nahi sikhaya Excel kaha online sikho dekho naam and professiona is same sir seriously aap bahut ache se sikhate hai.
DEAR SIR
I DONE INVOICE THRU VLOOKUP FIRST TIME AND I DONE SUCCESSFUL I WATCH MORE THEN FIVE TIME YOUR METHOD IS VERY EASY AND UNDERSTAND. THANKS A LOT
NOW I WILL TRY XLOOKUP LETS SEE
Thank you so much sir for this video!
A topic that I would like you to make a video on is Pivot Table.
It plays a very important role in practical life.
Awesome tutorial, thanks for sharing. Your way of teaching is very interesting
You are an Excellent Teacher on UA-cam. It is very important for every student to learn from you. I like your Teaching video. Excellent training method.
Bht saal se pareshan tha .
Vlookup ratt liya tha but samajh nhi aaya tha.
Aaj samajh aa gya..
I interested for complete course
I really love the way to teach.... Its became very easy for beginners like me to understand and perform on exel. But could u plz guide me how to download excel for free...
I think u should also give the link of data on description for our practice .
That will be more beneficial for us
agree
Trust me, I learned a lot things from this video. Am really thankful to you.
At the starting of the video. I thought , he is just promoting the brands , but when i watched the full video , i would like to say that , I invested my time in the right place.# thankyou so much sir for the video❤
Hello Sir,❤❤❤
I really loved this class, easy, simple, and sorted. I want more helpful videos like this to crack excel.
Kahan se khoju VLOOKUP
to be honest i dont know anything about vlookup but thnx to this video ive learned alot about vlookup.... brother you're doing good.... million thanks to you man..... im having excel test for my job interview process tomorrow and u helped me alot.... kudos to you..... lots of love brother..... god bless my man
Just because of your one point that our column should be in the extreme left my formula got corrected otherwise I have 2-3 values but unable to apply the same . Thanks for sharing mistakes that we do while applying a formula.🙏
Thanks sir
Thank you, explained in such a beautiful way. Easily understood 👍🏼
Excellent lecture on Excel sir mindblowing and mind opener video😎😎
Sir, very easy to understand good job thanks for all your help because next week there is my interview and they will ask about excel and accounts..so thank you👍🏻
👌Your way of explaining fantastic, keep continue in rocking style. You know what people never feel bored in such way which you follow. 😊
Thanks sir ab ITT Mai sab impress hojayenge
Nicely presented and elaborated. Well done Indev . Keep it up 🌼🌼🌼
Sir, ur teaching is awesome, I watched my v-look up, this the No - 1
really Sir first time i tried to learn Excel nd by seeing your vlookup video you make excel as like ABCD awesome Sir
This is great package of excel , sir... love you
Ery good sir bank ke liy best
Thank you sir....my all doubts of vlookup are cleared and now I'm all set about vlookup
Sir, very easy to understand, nicely explained, and humorous too which is nice for the learning process.
Respected sir,
I've been watching all your Excel as well as GST and all other videos. Your Teaching method is really User-friendly.
My suggestion is try to make a Video on "INDEX MATCH"
Regards,
Thank you
I don't think I will ever forget the learnings from this video
Did u still remembered this formula ?
Really Appreciate your lecture, Training, and way of teaching, which are most important for all who want to grow & improve their life, especially VLOOKUP.
Sir apki Wajah se mujhe vlookup clear ho gya hai
Hello Sir, I want to learn advanced excel... may I know when you are uploading the same?
He won't do it here in youtube... Only in Edu91 website
Sir I want all questions of excel for practice if it's available so pls revert me
बहुत ही अच्छे से समझाया है आपने। धन्यवाद गुरु जी
I am from Pakistan and watching your video 1st time, your way of explaining every detail was excellent. I easily understood every point you mention in the video. 👍👍👍
Sir, please kaam ki baat jada kare.. likes subscribe ka marketing mat kijiye.. video useful hoga to apne aap like milenge...
Right 😢❤
Sahi baat hai 🙌
Sir are there some pen drive classes available for class 12 .... Sir i am a big fan of you ... Want to become a chartered accountant 😊
You can check edu91.org
Wah Sir, 👏🏻👏🏻👏🏻 Kay Baat hai.
Thank you 🙏🏻 so much
Here is a short story about me just few minutes ego my Manager had given some work where I had to do some data segrigation. I was struggling badly then I saw this video and i completed the work. Thank you sir for this video. If anyone can describe Vlookup this was the most easiest one.
Sir ITT me ap hi pdhana shuru krdijiye😉 satellite classes k through..
Jab samne teacher padaa raha hota hai tab to bacche padte nahi hai satellite se to pad chuke 😂
Learning start from 3:58
🙏🏻❤️
Aap abhi ho kya ?? Mere ko excel sikhna he ...rab di kasam kamal ki sikhate ho app ji
Thank you sir for sharing your awesome tutorial, you make us. Understand in a very easy way. Please keep sharing you videos
3:50 skip
Finally i have understand the concept, after watching this video
I used this method in data with thousand entry, n it work great in that. Thank you 🙏
I found this channel very late but it's really helpful for me.... Thank You So much SIR for this wonderful explanation and guidance :)
Professionals(CA, CMA, CS) logo ki baat kuch alag hoti hai... Very sir
I have seen so many video about vlookup but nobody better than you...most important I'm confusing abt F4 and you clear my doubt so well
bhai F4 wala key se ho hi rha hai kuch or range wala kya hai smj hi nhi aaya smja skte ho.
Kya baat Arora saab. 🙏👍
I love the way you teach which is making this video exciting. I learnt everything you taught in this Video. Thanks Mr. Arora. And please make some video for "what kind of work business Analysts does using excel"'.
😘
Thank you so much sir for amazing but detailed explanation.
Brilliant Neeraj sir . you made this program very easy. Thanks for your support.
Itni videos dekhi aaj tak kuch smjh nhi aaya and this video..ek baar m sab smjh aagya ...bht easy h.
Sir please make video on pivot, how to prepare dashbord, index and match function.
Excellent video sir...... only with in 2 or 3 minutes.. I am able to find my mistake... which I done in my excel sheet. Thanks for this video.
Thank you so much sir . Learned properly and practiced also in my data
Thank you so much sir❣️
Please upload videos continously.
Like is always much more than your target.
You have presented this video in interesting way.Really useful video to understand Vlookup.
very informative video i searched on many channel but the way you explained 3-4 time in different manner was amazing.
would also like to know how to make invoice in excel if already shared please share the link it is very important for me.
Maza aa gya. Awesome video. Thank you very very much sir ji
Thank you sir mene kafi videos dekhi h excel se related but apke samjhne ka tarika bahut achha hai....
Ksm se Shaab kya smjhaya hai aapne....
You are great brother. I was understing very difficult to vlookup.
But not now😊
Thanks again bhai shaab💓
Thanks a million sir
The best and easiest way I have ever experienced for Excel learning.
Easy to Understand. Appreciate effort that has been put in
Thanku so much sir for such a wonderful explanation of this topic. Loved the way u taught us each intricacy of the topic❤❤
Bhaisahab, Inter CA toh aapke videos dekh ke clear ho gaya, ab lagta hai articleship mein bhi aapke videos se bohot labh hoga
I learnt very easily of VLOOKUP Excel formula....
Thanks Sir.... For your teaching 🙏🙏
Sach me sir mane Vlookup ka vidio dekha but apki bat hi alag ha thanks
Great,,has been explained in a theroitical way,,,genuinely can't be founded on UA-cam by another one same way of teaching.
Thankyou so much sir, I know I am too too too much late but seriously bohat faidha hu rah hai muje apki videos se... And I am learning excel from your page even lecture vise this was my the 4th lecture, Respect from Pakistan ❤🇵🇰 @excel for beginners
Thank you very much,with fun i learned excel vlookup.very intresting.
Thanks a lot sir great experience , basics Clear about v look up
Realy , such m itne asan tarike s kisi n nhi samjaya
Thank You very much for such a wonderful teaching.
Sir apka padhaya poora samjh me aaya bahut accha laga it' s made me fan of you in Excel.
Thankyou sir
all doubts cleared sir
thank you so much...
Dear sir , thank you so very very very much sir
it saved my 5 lakhs rupees due to recheck by your vlookup function, respect from heart!!
A lovely way of teaching does not bore even learning from long video.💓💓💓
now i realized, why freezing is compulsory! Thank you for this video sir!
Thanks sir , vlookup samjhne ke liye , aaj se pehle bhot confusion hota h formula bhul jate the but ab nhi bulenge
Your videos are really amazing, it would have been super great if you have provided us the link to worksheet you were working on so we can follow you otherwise best channel for learning excel
🤣