VLookup in Excel Part 1 | VLOOKUP सिर्फ़ 30 minute में (हिंदी) Excel Lecture 4 | Neeraj Arora
Vložit
- čas přidán 13. 12. 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.
![How To Apply VLOOKUP and XLOOKUP Formula on Large Data in Excel [Hindi] #excel](http://i.ytimg.com/vi/gAY9is-ahQY/mqdefault.jpg)
🔥 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😅
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 !
Thank you so much sir...your classes are helping me a lot to learn excel in the proper way and gain some confidence🙏
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
Finally is vedio ko dekh kr seriously samjh m aya vlookup itna asan h.....this is it
Yes.. same here
Easy to Learn, Easy to Understand and Fun while learning, keep going Sir, thank you.
The way of u teaching us , its really very interesting and easy to learn 👏
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...
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. 😀
awesome explanation. till now i was always afraid of vlookup, but now you have made it so simple . Thanks a billion...
What a teacher🔥 i love the way you teach us🤗
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.
Much awaited video of the whole excel series!!! Thank you so much sir!❤️
More to come. Thanks. Please share with all.
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 :)
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
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.
Bht saal se pareshan tha .
Vlookup ratt liya tha but samajh nhi aaya tha.
Aaj samajh aa gya..
I interested for complete course
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.
Awesome tutorial, thanks for sharing. Your way of teaching is very interesting
I think u should also give the link of data on description for our practice .
That will be more beneficial for us
agree
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.💜
You are an Excellent Teacher on CZcams. It is very important for every student to learn from you. I like your Teaching video. Excellent training method.
Nicely presented and elaborated. Well done Indev . Keep it up 🌼🌼🌼
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
Trust me, I learned a lot things from this video. Am really thankful to you.
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
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...
This is great package of excel , sir... love you
Ery good sir bank ke liy best
👌Your way of explaining fantastic, keep continue in rocking style. You know what people never feel bored in such way which you follow. 😊
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❤
I don't think I will ever forget the learnings from this video
Did u still remembered this formula ?
Excellent lecture on Excel sir mindblowing and mind opener video😎😎
really Sir first time i tried to learn Excel nd by seeing your vlookup video you make excel as like ABCD awesome Sir
Sir, very easy to understand, nicely explained, and humorous too which is nice for the learning process.
Thanks sir ab ITT Mai sab impress hojayenge
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
Maza aa gya. Awesome video. Thank you very very much sir ji
Thank you, explained in such a beautiful way. Easily understood 👍🏼
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👍🏻
Sir, ur teaching is awesome, I watched my v-look up, this the No - 1
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
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
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
At 29:43 I loved it....it's too funny and superb. Keep it up bro...comedy timing sense is awesome🤣🤣🤣🤣😂😂😂😂😅😅😅😅
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
Sir I want all questions of excel for practice if it's available so pls revert me
Thank you sir for sharing your awesome tutorial, you make us. Understand in a very easy way. Please keep sharing you videos
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
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 😂
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 🙌
Thank you so much sir for amazing but detailed explanation.
I found this channel very late but it's really helpful for me.... Thank You So much SIR for this wonderful explanation and guidance :)
Learning start from 3:58
🙏🏻❤️
3:50 skip
Thank you so much sir❣️
Please upload videos continously.
Like is always much more than your target.
Thank you sir....my all doubts of vlookup are cleared and now I'm all set about vlookup
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.
Finally i have understand the concept, after watching this video
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"'.
😘
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.
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.
Wooow appreciating.....
Thank you so much sir . Learned properly and practiced also in my data
Beautifully explained...thanks I have a doubt and it was beautifully cleared
Brilliant Neeraj sir . you made this program very easy. Thanks for your support.
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.
Really Appreciate your lecture, Training, and way of teaching, which are most important for all who want to grow & improve their life, especially VLOOKUP.
Finally someone could explained it!
Thanku so much sir for such a wonderful explanation of this topic. Loved the way u taught us each intricacy of the topic❤❤
ONE OF THE BEST
You have presented this video in interesting way.Really useful video to understand Vlookup.
Wah Sir, 👏🏻👏🏻👏🏻 Kay Baat hai.
Thank you 🙏🏻 so much
Intresting video sir........Thankyou so much::::
बहुत ही अच्छे से समझाया है आपने। धन्यवाद गुरु जी
Easy to Understand. Appreciate effort that has been put in
Thank you so much for this video... its very helpful .. u have cleared my concepts .
बहुत अच्छा विडीओ बनाया है भैया आपने!
इस विडीओ से सीखने को मिला।
Kya baat Arora saab. 🙏👍
Thank you very much,with fun i learned excel vlookup.very intresting.
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. 👍👍👍
Maza aagaya sir.
now i realized, why freezing is compulsory! Thank you for this video sir!
Thanks a lot sir great experience , basics Clear about v look up
Wowwww ..
U r just awesome !!!
Really enjoyed
Respect..sir god bless u
Professionals(CA, CMA, CS) logo ki baat kuch alag hoti hai... Very sir
Great sir..
Great sir
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.
Awesome video
Thanks for sharing this video.
Very Very Good teaching. Very Very interesting to listen your voice always. 🙏🙏🙏👍👍👍💯💯💯🌹🌹🌹
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.
Awesome sir
A lovely way of teaching does not bore even learning from long video.💓💓💓
Really great video