Vlookup in Excel | Excel Vlookup formula in Hindi to become master in excel
Vložit
- čas přidán 31. 05. 2024
- Learn Satish Sir courses with Certificate
Download Course App : bit.ly/3BWfQVa
Courses Website :bit.ly/skill_course
Excel Vlookup formula in Hindi - Is video me maine excel ke vlookup ke formula ke har ek option ko explain kiya hai aur wo bhi excel vlookup ke 15 example ke sath, Vlookup formula excel me ek aisa formula hai jo har ek office me use kiya jata hai to isme aap kya kya sikhoge iski list maine niche diyi hai time stamps ke sath.
#ExcelVlookup
#VlookupFormula
#VlookupHindi
Timestamps
0:00 Introduction
00:05:20 - Excel Vlookup Introduction - Part -1
00:46:52 - Vlookup Formula Range Lookup - Part -2
00:58:36 - Use of IFERROR Formula in Vlookup - Part -3
01:04:31 - Nested Vlookup in Excel - Part -4
01:14:43 - Dynamic Filter using Vlookup - Part -5
01:28:03 - Double Vlookup in Excel - Part -6
01:44:00 - Multitable Vlookup - Part -7
01:50:23 - Multiple sheet vlookup in Hindi - Part -8
02:04:26 - Reverse Vlookup in Excel - Part -9
02:14:30 - Reverse Lookup using Index, Match - Part -10
02:22:17 - Vlookup and Match - Part - 11
02:30:25 - Vlookup and Find - Part -12
02:42:58 - 2 Lookups Value - Part -13
02:47:39 - Vlookup Twist - Part -14
02:58:17 - MIS Report using Vlookup - Part -15
All Excel Old videos Practice Files are available Inside "Skill Course" App
Follow the steps in order to download Satish sir All Videos Practice Files :
Download "Skill Course" app from Play Store - Home Tab - Study Material - CZcams Channel Practice Files - Learn More Channel Practice Files - All OLD Videos Excel Practice Files
------------------------------------------------------------------------------------------------------------------------------
Learn Satish Sir courses with Certificate
Download Course App : bit.ly/3BWfQVa
Courses Website :bit.ly/skill_course
Course Features :
✅ सभी Videos सरल हिंदी भाषा में
⬇️ Download Video in APP
✅ Basic to Advance Courses
✅ Practice Files (Yes)
✅ PDF Shortcuts
✅ Course Completion Certificate
✅ Instant Access
✅ Watch on Desktop : skillcourse.in/
------------------------------------------------------------------------------------------------------------------------------
Telegram channel: telegram.me/learnmoreindia
Check our latest blogs: learnmoreindia.in/
------------------------------------------------------------------------------------------------------------------------------
Social media Pages:
Facebook Page Link: bit.ly/3CvGlBT
Instagram Page Link: bit.ly/3f9R37u
------------------------------------------------------------------------------------------------------------------------------
My Other Channels:
Real Tutorial: ✅
/ @realtutorial550
Complete Technology:✅
/ @completetechnology
Learn more shorts:✅
/ @learnmoreshorts
Satish Tech (Marathi):✅
/ @satish_tech
Tally Tutorial:✅
/ @tallytutorial
Exce Tutorial:✅
/ @excel_tutorial
Learn More:✅
/ @learn_more
Curiosity: ✅
/ @curiosity9432
------------------------------------------------------------------------------------------------------------------------------
My CZcams Gears :
Best Mic for Recording (Condensor Mic): amzn.to/2UUMDnH
Best Mic for Recording (Dynamic Mic ): amzn.to/3pQgyvD
My DSLR Camera Canon 200D: amzn.to/39ciw3E
My Laptop (Video Editing): amzn.to/2UXQj8h
Laptop (Office Use/ Home use / Budget Laptop) : amzn.to/3l0pniw
Antivirus: amzn.to/3l3TIgi
Screen Recording Software: bit.ly/2J39n2j
Video Editing Software: bit.ly/3nOPlri
Green screen with Stand: amzn.to/2KAl1Cu
Tags :
Vlookup in excel, vlookup in excel in hindi vlookup formula in excel, vlookup, vlookup formula in excel in hindi, how to use vlookup in excel, how to sue vlookup, vlookup formula, vlookup basic to advance, vlookup for beginners in hindi, excel vlookup tutorial in hindi, ms excel vlookup tutorial in hindi, Microsoft excel vlookup
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 😅😊😊😊😊
U r such a hardworking teacher...salute ur efforts..excellent explanation
Really maza aa gya bhut sare doubts clear ho gye
Thanku
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..❤🙏
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
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............
Sir, your style of teaching is absolutely Genius and remarkable, it's so easily understandable.
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...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.
Thank you sir ...Thank you so much , i can't explain how much I wanted the topic...❤️
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.
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, 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.
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.
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
बहुत सुन्दर माँ भगवती करे आप इसी तरह लोगों की परेशानी दूर करें और आप का ज्ञान अथाह बढ़ता रहे
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
This is the type of teaching
Exellent Satish sir.. Thank s for your work & systematic way to provides valuable knowledge @learnmore
Bahut bahut dhanyawad sir apne aaj sare doubt clear kar diye Vlookup ke ...bahut bahut dhanyawad sir ji
This video is a gold mine for complete beginners like myself, many thanks for your time and effort, highly appreciated.
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 ??
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
Terrific, superb, mind blowing, just toooo good.
Thank you sir for all your efforts I am glad that you are here to teach us such a difficult thing for free. May you get all the success in your life.
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
Amazing video. No words to define your heard work 🙃
Thank You So Much... Never thought I would learn Vlookup so easily... Hats off to your dedication sir... ♥️
what a perfect teaching style , Sir i love your briefing style .
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
Really sir, u are very hard working. Thx sir, for sharing such a useful knowledge and for making such a detailed video for us.
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
The work of teaching so great l love it your great and you are genies
Thanks iIqbal bhai
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
Although its not going to be my profession.
But requires little about this subject knowledge.
So wanted to learn little bit of it.
You explanations are excellent.
Love you.
Great.
It's very very very helpful video not only for beginners but also for those who are working in their offices....
Thank you so much sir for giving us these types of videos
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
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.czcams.com/video/5n4vaY8XjrE/video.html
Best teacher I have ever saw on youtube
Very Very Help for me i will going to go for interview, I was saw this video. Very helpful. Thank you sir !!!
Sir hlookup par Master video banaye
❤️
Sir you are amazing, your way teaching is excellent, I am easily understood everything you told about and now I am confidently use exel......
Thank you so much sir ❤️
Sir U did a fantastic job and we can easily understood excel with lots of confidence. Thanks a lot Sir
SIR MAKE VIDEO ON MS ACCESS 2019
BECAUSE ONLY LIMITED VIDOES ARE THERE ON CZcams
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
Really really U are a great & hardworking teacher.. Salute sir 🙏🏻🙏🏻
Sir download size 480p tak kare 360p ka quality thik nhi h.
your videos are very helpful to us.
Please make more and more videos on other software like AutoCAD.
Because your way of explaination is very nice & understandable.
Thanks sir.🙂
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
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))
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 Jo samjhaya bhot achhe se aaya. Best video for Excel learning. Thanks Sir.
Dear Sir, your nice instructor, you know well how to deliver. thanks a lot.
FANTASTIC, VERY NICE TEACHING TECHNIC SIR....... KEEP IT UP
I'm sure sir aapki video dekhi bhi nhi h or all subscribe kr liya aapki video or like or comment bhi 🎉🎉👏👏👏👏👏
Great Sir ... You did an excellent job... I am from Pakistan and I am a big fan of yours ....
Sir sachme . Dusre youtube channels me aisa detail and complete explainations nahi hai. .. nicely explained.
Sir ap students ki bahot help karte ho
Thanks a lot 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
aap bohot he details me batate ho. itna details koi nahi batata. mai ne aap se boht kuch sikha hai. thank you so much
I have never seen a person who explain in such a beautiful way......🙏
Thanks a lot for explaining vlookup with different variants.
Excellent Teaching way, Amazing, & Very important Vedio..
you are just like god to us, because of you so many people will become skillful. Thank you sir.
Sir, you are a great teacher. Salute you.
Ap itana acche sa padhate hai jisa ki apko sari jankari detail ma pata ho
I must say that you are mind blowing Sir you always give your 1000% for each and every video. I appreciate Sir 🙏🏽
Thanks you so much for sharing knowledgeable video. I like your teaching method. Your Genius Professor.
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
U r such a hardworking teacher...salute ur efforts........excellent
AAP ki baje she hame bahot kuchh shikhane ko mila sir
Excellent. Best one for learner as well as exports of MS Excel.
amazing sir, i never thought that i can learn but your videos made it super easy..
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
Sir, you explain very easy way. Thanks for this Gr8 lecture.
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
You are amazing Sir
U have solved all my mystery.
Thanks alot 🙏🙏
Sir mai kolkata se hoon. Aap ka chanel mai new subscriber. Sir aap pivot table or hlookup ke upar ek vdo banaiye pls. Aap ka teaching bhot hi badiya hai.
Thanks and regards
Arghya Banerjee.
Very Knowledge gaining video, Thanks Mr. Dhawale
You explain very well sir and double data validation mind blowing..
I think you are the only teacher on CZcams, who teaches with all the nitty-gritty. Thanks a lot. Doing Great Job 💯👌
You are best teacher for computer knowledge in the world
Sir aapka video bahot achcha hai easily samaj me aata hai
Sir is vedio me aapka efforts clear dikh raha hai.. Most powerful and useful vedio
Yes yes you are amazing 🙏🙏 god bless you 🙏 sir..thanx .am always follow you
Beautiful explanation and the best part is you explain each and every details in hindi.
I'm ur new subscriber sir ,I love to watch ur videos because only in ur videos I can get all things at once..ur work is admirable...pls keep uploading such kinda video...I'm beginnner nd learning a lot from ur videos . U r unique from other CZcamsRS.
Really it's a very important for everyone, Salute Sir 😄
Sir you are my best teacher I am from Pakistan ❣️
Sir, your excel tutorial are best on youtube channel
Best video to learn vlookup from basic to advance ..very helpful for me.
Thank you
Sir I am CA Inter clear currently doing Articleship and your videos are very helpful for me during Audit.
God bless you Sir
THANKS FOR THIS SATISH SIR WITH LOTS OF RESPECT
Sharab Jo video banate bahut acche banate Ho Sabke Liye bahut acche vah video aur sab padh paate aapke vajah se Sar aapko Mere taraf se खूब-खूब dhanyvad Sar bahut badhiya kam kar rahe Sar aap aise kar rahe ho aur Humko padhaate Raho Jay Hind Jay Bharat
Your teaching style is incredible, everything is explained beautifully
Guru ji pranam 🙏 bahut acche se padhate ho aap . Bhaukaal bulkul bhi nahi hai sab asli maal hai aapke video me 🙏👌
Your Teaching Is very Excellent Sir... Thank You So much...😊
Seriously, awesome insightful session, sir!
Excellent methodical and lucid presentation! It is obvious You have worked hard on the lecture. Very useful
Aap jaise teacher mil jaye to kuchh bhi impossible nhi h
Thank you sir very informative and helpful. No one teach even in class such like you.
Really Impressive sir , I learn a lot from you