VLookup in Excel Part 1 | VLOOKUP सिर्फ़ 30 minute में (हिंदी) Excel Lecture 4 | Neeraj Arora
ฝัง
- เผยแพร่เมื่อ 28 ส.ค. 2024
- #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.co...
😍 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.
![[TH] VALORANT Champions Seoul - Grand Final - EDG vs TH](http://i.ytimg.com/vi/WvObMc9VelI/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
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
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.
Bht saal se pareshan tha .
Vlookup ratt liya tha but samajh nhi aaya tha.
Aaj samajh aa gya..
I interested for complete course
Finally is vedio ko dekh kr seriously samjh m aya vlookup itna asan h.....this is it
Yes.. same here
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
video starts from 03:84, thank me later.....
Thankyou
03:48 aactually
Thanks 😂
Me watching ur comment after watching full video 😢
@@rutvikjani5154😅
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...
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
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.
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.💜
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.
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. 😀
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 🙌
Awesome tutorial, thanks for sharing. Your way of teaching is very interesting
Extremely nice explanation. It cleared all of my doubts..
Thank you very much for his wonderful contribution in society !
Very Very Good teaching. Very Very interesting to listen your voice always. 🙏🙏🙏👍👍👍💯💯💯🌹🌹🌹
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
I think u should also give the link of data on description for our practice .
That will be more beneficial for us
agree
Much awaited video of the whole excel series!!! Thank you so much sir!❤️
More to come. Thanks. Please share with all.
Maza aa gya. Awesome video. Thank you very very much sir ji
Superb dear sir ji i like it... really fixed for long time in my mind i am never forget this formula and your explanation is very very excellent.. thank you sir ji...🙏🙏🙏
Thank you so much sir...your classes are helping me a lot to learn excel in the proper way and gain some confidence🙏
I don't think I will ever forget the learnings from this video
Did u still remembered this formula ?
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.
Dude You are The Great 👏
No one else could have taught me this better than you, Thanks a ton 👍
Jai Hind 🕉️🇮🇳
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 👏
Really Appreciate your lecture, Training, and way of teaching, which are most important for all who want to grow & improve their life, especially VLOOKUP.
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 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...
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.
बहुत ही अच्छे से समझाया है आपने। धन्यवाद गुरु जी
Excellent lecture on Excel sir mindblowing and mind opener video😎😎
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
Great,,has been explained in a theroitical way,,,genuinely can't be founded on TH-cam by another one same way of teaching.
What a teacher🔥 i love the way you teach us🤗
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.
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.
Awesome vedio sir.
According to my personal opinion, it's one of the best vedio in TH-cam channel.
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
Nicely presented and elaborated. Well done Indev . Keep it up 🌼🌼🌼
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
At 29:43 I loved it....it's too funny and superb. Keep it up bro...comedy timing sense is awesome🤣🤣🤣🤣😂😂😂😂😅😅😅😅
Thanks sir ab ITT Mai sab impress hojayenge
Thank you, explained in such a beautiful way. Easily understood 👍🏼
I found this channel very late but it's really helpful for me.... Thank You So much SIR for this wonderful explanation and guidance :)
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.
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
Excellent explanation, very helpful video, thanks from pakistan ❤️
Thanks for teaching in such an easy way, I am from Pakistan.
This is great package of excel , sir... love you
Ery good sir bank ke liy best
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
Professionals(CA, CMA, CS) logo ki baat kuch alag hoti hai... Very sir
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.
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 I want all questions of excel for practice if it's available so pls revert me
Sir apka padhaya poora samjh me aaya bahut accha laga it' s made me fan of you in Excel.
Thankyou sir
Sir maza aa gya apki video dekh kar this is certainly the best video on vlookup I have ever seen
please keep posting these valuabel content love from jaipur❤
Learning start from 3:58
🙏🏻❤️
3:50 skip
Thank you sir mene kafi videos dekhi h excel se related but apke samjhne ka tarika bahut achha hai....
Your way of teaching is tremendous sir ji
Today my all doubts are clear for vlookup
Thanks a lot
I learnt very easily of VLOOKUP Excel formula....
Thanks Sir.... For your teaching 🙏🙏
This is the best video for learning vlookup in the world .... The video is too much interesting......... *Sir I request you to teach whole advance excel with formulas..............*
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 sir....my all doubts of vlookup are cleared and now I'm all set about vlookup
really Sir first time i tried to learn Excel nd by seeing your vlookup video you make excel as like ABCD awesome Sir
Thank you sir for sharing your awesome tutorial, you make us. Understand in a very easy way. Please keep sharing you videos
honestly you r great...may you prosperous more...respect and love from Pakistan
Intresting video sir........Thankyou so much::::
Great Video Sir, seriously..nice guidence for VLookup formulas.
Much Explanatory and Extremely nice explanation along with Errors
Amazing video and keep growing and teach us as well ❤💯
Its me loving this channel from Nepal.❤
Very Nice teaching.
And also i am saving around Rs 3000 for pursuing this through any excel teaching institute
in one word thank you for teaching great experience with this.
sir amazing video..or sbse best line...oo balle balle...mjaa aaya🙏🙏
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💓
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!!
Thank you so much sir❣️
Please upload videos continously.
Like is always much more than your target.
EXCELENT WAY OF EXPALANATION Thanks for sharing your knowledge
The superb video for to understand vlook .. Thank you so much..
now i realized, why freezing is compulsory! Thank you for this video sir!
Thanku so much sir for such a wonderful explanation of this topic. Loved the way u taught us each intricacy of the topic❤❤
Thank you so much sir ....now I understood the formula of vlookup
awesome explanation. till now i was always afraid of vlookup, but now you have made it so simple . Thanks a billion...
बहुत अच्छा विडीओ बनाया है भैया आपने!
इस विडीओ से सीखने को मिला।
Aap ka tareeka kafi achha lga or bor bhi bilkul bhi nhi huaa thank u so much
I learnt vlookup from you! Thanks, mate!
Thanks a million sir
The best and easiest way I have ever experienced for Excel learning.
Realy , such m itne asan tarike s kisi n nhi samjaya
U r really great sir, bohot hi majedar class thi… thankyou
Thanku sir you teach very simple and gently therefore I see your videos over and over 👍 .. Request: please make video for if,mod,iserror,iferror, thankuuu...
Thank you so much sir for amazing but detailed explanation.
Supern sir ,Thank you for this gem👍☀️😊
It's really very helpful video thank you so much sir 😊😊
What an entertainment to learn vlookup, awesome! Thank you very much!! Mazza aa gaya bhai sahab!!
Aap abhi ho kya ?? Mere ko excel sikhna he ...rab di kasam kamal ki sikhate ho app ji