क्या है Vlookup? (हिंदी में)
Вставка
- Опубліковано 22 лис 2018
- 👉 FREE Excel Course. ENROLL NOW: event.webinarjam.com/register...
What is Vlookup??
Download the workbooks used in this video: learn-with-lokesh-lalwani.thi...
Friends, as an Excel user, the most common question comes in is how to fetch some data out of a huge database from at one go? And the answer is Vlookup...This is one of the most amazing functions in Excel. We can apply Vlookup to compare two different datasets also.
Syntax:
Lookup Value = This is the common field in both the datasets.
Table Array = selection of our master data i.e. a database where we have those values which we need to match like PAN number, Emp ID, Phone Number etc. and those values also which we need to fetch on the bases of the lookup value like Employee name, Salary, Department etc.
Col, Index, Num = This stands for Column Index Number, this refers to that column number of our table array from where we need to fetch the values.
Range Lookup = This could be either True (Approximate Match) or False (Exact Match). In this example, we will be using False.
For more such videos subscribe to our channel: / @learnwithlokeshlalwani
Follow me on Instagram: learnwithlo...
Learn Excel from my in-depth course: hi.switchy.io/ExcelMasterclass 🔥🔥
Sir do you provide online training
Please let me know and drop your contact no.
@@ARIFSAIFIFARHAN hi
Shabby.
,,,,
Nice video 😊👍
Nice video sir
Since I have an habit of learning at more than 60 years of age, my child you have aardvark God gifted teaching ability and I pray for you from the core of my heart that Allah may happy with you.
I really appreciate your kind words and your prayers. I'm thankful for your support and encouragement.
My pleasure, however, please update for new topic
समझाने का तरीका काफी अच्छा है
Ek hota hai seekhana. Aur ek hota hai aisa seekhana ki samne wala kabhi bhool hi na paye. Aap ne itna ache tareeke se seekhaya ki ekdam clear hogaya. Waise tho bohot sare excel seekhane wale hai youtube me but muje aap ka teaching style acha laga.
Thank you so much for that lovely comment.
समझाने का तरीका बहुत ही आछा है ।Thanks
The way you explained the single parts and functions of vlookup, I really appreciate your efforts. And I was not aware about vlookup, I went for interview and he asked me to learn vlookup, he said I can give you 3 days more for the same, after watching this video I’m damn sure that I can easily put vlookup in any sheet and I can get ready every data with the help of this video.
Τнäиκ чöü·♡ very much.❤️🙏🏻🙏🏻🙏🏻
Multiple Column is also a nice way to make work easy.
Right now u just saved my 5 hrs of struggle which i usd to do since 2 years every 3 months uffffff thanks brother it really worked 🥰🥰🥰
You are the best , you are the best, you are the best. I have no words to express you my thanks. You saved my life. My boss has been kept telling me to learn it as I moved to a dept where vlook is imp. I thank God I found your video. So clearly explained. I am confident.. 😇👌🤞🙏
God bless u.. The thing is u cleared minor doubts too..You have covered everything..well presented👌
Update- Main seekh gai.. I learnt it.. I just tried and succeded.. omg i can do it.. Thank you Mr Lalwani
Sir apke sikhane ka tarika baki sb se alag hai jo ki bahut achha hai is video me mujhe bahut achhe se samjh aaya tq...
After watching this video , I am highly confident that I don't need to watch another video on You tube about Vlookup
Such a great video sir. Thanks🙏🙏
Yes agree with your comment
Same here
Nhi hue sir ji
Thank you sirji for all your efforts. I went through your work on your website too. Thank you once again. With this sample data it becomes quite easy to practise all the command that you teach online.
Lots of respect and appreciation from Pakistan. Only you make excel look way easier. Hats off to you !
You don't know how much this video has helped me. Thank you so much.
Please always make video's on practically like you always did... It's very useful to understand actually how to use in office work... Thanks 👍🙏
ua-cam.com/channels/dY5JUg4SU4O3-bEqgkbh1Q.html
Really useful video, I watched so many videos, but this one made me understand the formula. 👍
m.ua-cam.com/video/CwtDMosjFAQ/v-deo.html
Yes ajtak koi bhi video maine is tarah simple tarike sena hi samza ...Bahot badhiya
Thanks sir pehli bar koi video achhi lagi jo meri samjh me aaya vlookup
Thanks , this looks easy because of your teaching sir, I was rejected in my earlier interviews because I didn't know it and now I am sure I will be selected .🙏
ua-cam.com/channels/dY5JUg4SU4O3-bEqgkbh1Q.html
ua-cam.com/channels/dY5JUg4SU4O3-bEqgkbh1Q.html
Hi namita
Perfectly explained...vry much useful to clear the doubts in this topic. Thanx
ua-cam.com/channels/dY5JUg4SU4O3-bEqgkbh1Q.html
Guruji, you have explained it so well. This was problem for me, now in understand it. Thank you so much.
Thank u sirji...bohat din se bohat logo ne bataya...but aaj he video dekhne k baad.. fully...samaj aya ki vlookup kya hai...and kaise use karthe hai...once again thank u sirji
Thank you for this clear explanation! The Vlookup function is very useful, particularly in large datasets I frequently work with 😊
samjhaane ka tareeka achha hai. Subscribed.
Thank you Sooooo much dear...
I have earlier seen a few videos, but their language, presentation remained ambiguous, but your video is a classic one, simply for the reason of it being a Very lucid and clear presentation and your voice and language@ Hindi is Superb !!!
No there is no need to watch any other video on this topic. I subscribed with Bell notification on 👍👍👍
Sir apka samjhane ka tarika bahut achcha hai . Excel se related sari problem ko achche solve kiya jata hai. Thanks sir
Thank you, Sir!! Specially for telling us about that it doesn't work on LHS, till date i wasn't aware
Thanks.. V nicely explained. New user.. Subscribed.. :)
Best part is you also tell what keys you press while changing work sheets, selecting full cols, inserting etc.. Which is v useful for a general user.
👉Query: what if I want the value from say 168th col... How do I calculate the col. No. In that case?
you have to do it manually there is no other option to count the column dinamicaly
Owsum explain for vlookup excel sheet .....Isse behtar or koi explain nai kar Sakta ....so easy thanku sir
Many many thanku sir , great video sir , is content pe boht videos dekha lekin apka video dekh kr sab clear ho gya , you are a great teacher 😊😊😊
Really useful this Video , i want to learn about Vlookup
Hi Divyesh,
Glad you liked it :)
Also, i am about to launch an Excel FREE course soon, I will announce it our telegram channel, where we post new updates everyday. So, don't forget to join here: t.me/learnwithlokeshlalwani
Stay Connected :)
Happy learning:)
Lokesh Lalwani
You are such a best teacher sir .....Maine aaj pheli baar aapki video dekhi hai aap bahot accha smjhate hai.
Vlookp is taraj abhi tak kisi ne nahi samjhaya.
Bahut khub
Your teaching approach is so unique and superb, thanks
Thank you ..
You teach it in such a simple and detailed way.. so anyone can learn with ease
Bhaiya aapke jaisa aaj tak koi nai samjha paya thanks bahut ache se ghus gaya dimaag mein
बेहतरीन प्रस्तुति, आपसे निवेदन है कि ऐसे एक practice sheet भी अपने लिंक में जोड़ दें, आपकी वीडियो काफी असरदार हो जायेगी।
Clear and very precise- easy to understand
Well & patiently explained video, no bullshit & crap like other youtubers. straight outta point. Hats off to you Sir.
Thanks Lokesh ji for this superb video. Very easy to learn from this video.
VERY DEEPLY AND CLEARLY TEACHING TO US , THANKS
I've been trying to learn this Vlookup for so long but unable to, finally leant this here at your channel, you got my subscribe.
Thank you so much ❤️... you made my concept clear.🙏
Sir your really Great pahle aapne problem btayi fr solutions btyaa
Isse hume kaafi smjhne me asaani huyi
Thank you so much for making this video. It helped me a lot.
Its a very useful and knowledgeble video..thank you very much sir. For teaching us in very very simple ways...
The way u explain that was so easy, thanks, it will definatly help me in future.
Thank You So Much Sir For helping........ Really Greatfull To have You....
Dear Mr Lokesh .. Really it helped me A-lot , and you explained it very Good and in an easy way... May Allah give you more success ... ameen .
So nice of you
Sir bahut badhiya tarike se aapne samjhaya hai jo galti log krte hai usko bhi apne issi video me bta diya hai... First Time apke chanel pr aaya aur apka fan ho gya😊
Bahut sare logo ka vlookup vodeo dekha but itna easy form me samjhaye aap aur koi nhi samjha pata
Love you sir❤
Aapka bahut bahut shukriya! Aapka pyaar aur samman milkar mujhe bahut khushi hui. Main bas yeh koshish karta hoon ki main complex concepts ko simple tarike se samjhane mein safalta prapt karoon. Aapko mera vlookup video pasand aaya isse sunke mujhe atyant prerna mili.
Mujhe khushi hai ki aapko video helpful laga aur aapko usmein jo galtiyaan hoti hain, unka samadhan mila. Aapka sahyog mere liye mahatvapurn hai aur main aapke fan ban gaya is baat se garv mehsoos kar raha hoon.
first time i understand full concept thanks a lot
Very useful thank you so much teaching us as a great teacher
thanks a lot lokesh for this useful video...saw so many videos but after watching this video i finally cleared all my doubts why and how it is used....keep uploading such videos...
best described...i have never seen such illustrative example before!
Ap buhat acha samjhate hain sir ...
Ap ke samjhane ka tareeka zabardast hai sir. 🎉🎉🎉
1st time on youtube who are really amazing man, that deliver right stuff to understand with easy way.
Thanks
Sir bohot easy tarilke se explain kiya.
Nice Sir 👍
Really you explain in a very simple and easiest manner, merey maan kaa daar nikal gaya for V look up
Explained very nicely. Thank you so much for the video.
Thank you 💕 brother... 3 din se try kr rha tha 😬 left right wala issue nahi pata tha 🥲 bas yahi problem thi or ye bhot badi problem thi ab tak 😅jab tak apki video nahi dekhi🥳thank you so much for ur explanation
Thank you so much for explaining it in simple way, now i can use Vlook without any issues.
Aapka Explanation bohot hi acha hai sir
BAHOT HI SAHI TARIKE SE SAMJHAYA, YOU TUBE PAR BAHOT SI VIDEO H PAR APP KI VIDEO KE BAD ME KARNE LAGA ,
I like your way of teaching iam very grateful to you , you brought vlookup formula with good explanation thanks sir plz make videos on other topics of Excel
👍👌 You Are Super Sir in Teaching Of Excel thank you Sir 🙏
From Pakistan.....very help ful videos
Thanxalot
Very helpful video. after see this video i don't need to see other videos
Thank you so much for the excellent explanation. God bless you.
No one teach me like this, I was trying to learn vlookup from many years but finally I learn through this video. Great work and explanation
I'm thrilled to hear about your successful learning experience! Your dedication to mastering VLOOKUP over the years truly paid off. I am delighted that my video could assist you in grasping the concept effectively.
Sir aap explain bohut correct karte ho
Bahut jabardast tarika hai aapka thanx
Yes really learning with LEARN WITH LOKESH LALWANI
Sir you are genious....really mai bahaut a66e se sikh gaye details......kash aap mere computer teacher hote...😟
Hello sir. Very nice and informative video again.
Sir can u make video on conditional formatting based on inventory manage. Means how we can manage inventory with conditional formatting. Like when any materials comes will be a different colour and when materials goes out will be different color. If it is in below maximum level or minimum level will be a different color. Thank you.
Wah, jabardast video
Maine ye function aap se hi sikha h
Aap bahut achha samjate h sir
Thank you so much
Very interesting class.... many Thanks for giving this lesson
such a great way of teaching .
Sir aap bahut axa padhate hain aap Se request hai ki Aise hi Viedo banaye ❤❤❤
Thank you very much
sir, you made my concept clear.
Classic define.. thanks for such knowledge in simple way ..
Thanks Naveen for your kind words :)
Good 1 cheez mujhe bhot achhi lagi 👍🏻
The way u Explain is Excellent,.
Thank so much sir aapne bohut achese samjhaye maine first time aapki video dekhi very nice 🙂
Thanks Sir, I am 36 years old and I have been working for 16 years, But today I understood vlookup.
same
Thank you for clearing these small but important points!
m.ua-cam.com/video/CwtDMosjFAQ/v-deo.html
Really Great Sir, i saw many videos but you solved my problem, Thank you so much.
Glad it helped you Rahul.
Sir tnku very much for ur guidance regarding vlookup ...it has made my work...
Thanks lott but I need more videos of your, it helped me to prepare my company work
Sir , First of all , Thank`s for for the free Knowledge, Plz keep sharing Sample Date to practice by following video .
Thank you sir bahut ache se samjhaya aapne thank you so much me ye vdo interview ke lea dekha rahe thi or interview me yahi qus pucha gaya or me aaram se ans de dea aapke karan thanks u for making this vdo 🙂🙂🙂🙂
Thank you so much for your comment. And most welcome.
Thanks Bhai bht kuch shikne ko mila apki vidio se🙏🙏🙏🙏
Thank you so much Sir, really helpful. I have used Vlookup for the first time coz of this video and I got the correct value.
Glad it helped
Very nice explanation. I am facing lot of issues in my office because of Vlookup after that I came here & watched your video. Now I will try it out tomorrow in my office confidently. Thank you Guruji😊❤
Sir thanks a lot currently i am in the office & applied your tact to the Excel sheet & result is successful. I have done first time V lookup as per your guidelines. Thank you very much for the confidence you given me❤
You are most welcome
ufff... maza aa gya sir... kya he kamal video hy... stay blessed
VERY GOOD VIDEO, GAGAR ME SAGAR HAIN YE VIDEO.
Yes sir bahut pasand aaya vedio
Such a beautiful video for new learner..
Thanks a ton for creating this video.
Thank you sir, very well explained...
Thank you sir bohot hi easy aur elaborate karke sikhaya aapne