क्या है Vlookup? (हिंदी में)
ฝัง
- เผยแพร่เมื่อ 28 ส.ค. 2024
- 👉 FREE Excel Course. ENROLL NOW: event.webinarj...
What is Vlookup??
Download the workbooks used in this video: learn-with-lok...
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: www.instagram....
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
समझाने का तरीका बहुत ही आछा है ।Thanks
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.
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.
समझाने का तरीका काफी अच्छा है
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
You don't know how much this video has helped me. Thank you so much.
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 🥰🥰🥰
Thank you so much. This was so simple to understand. I was trying to learn Vlookup since long but the way the logic was explained, it cleared all the doubts.
Glad to hear it. Thank you so much for your comment!
Yes ajtak koi bhi video maine is tarah simple tarike sena hi samza ...Bahot badhiya
samjhaane ka tareeka achha hai. Subscribed.
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 .🙏
th-cam.com/channels/dY5JUg4SU4O3-bEqgkbh1Q.html
th-cam.com/channels/dY5JUg4SU4O3-bEqgkbh1Q.html
Hi namita
Thank u so much sir for very simple way to learn VLOOKUP...
Owsum explain for vlookup excel sheet .....Isse behtar or koi explain nai kar Sakta ....so easy thanku sir
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.
Really useful video, I watched so many videos, but this one made me understand the formula. 👍
m.th-cam.com/video/CwtDMosjFAQ/w-d-xo.html
Thanks sir pehli bar koi video achhi lagi jo meri samjh me aaya vlookup
Sir apka samjhane ka tarika bahut achcha hai . Excel se related sari problem ko achche solve kiya jata hai. Thanks sir
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 👍🙏
th-cam.com/channels/dY5JUg4SU4O3-bEqgkbh1Q.html
Perfectly explained...vry much useful to clear the doubts in this topic. Thanx
th-cam.com/channels/dY5JUg4SU4O3-bEqgkbh1Q.html
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 😊😊😊
Lots of respect and appreciation from Pakistan. Only you make excel look way easier. Hats off to you !
Thank you for this clear explanation! The Vlookup function is very useful, particularly in large datasets I frequently work with 😊
Thank you, Sir!! Specially for telling us about that it doesn't work on LHS, till date i wasn't aware
You are such a best teacher sir .....Maine aaj pheli baar aapki video dekhi hai aap bahot accha smjhate hai.
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
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
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
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.
बेहतरीन प्रस्तुति, आपसे निवेदन है कि ऐसे एक practice sheet भी अपने लिंक में जोड़ दें, आपकी वीडियो काफी असरदार हो जायेगी।
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
1st time on youtube who are really amazing man, that deliver right stuff to understand with easy way.
Thanks
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
Very helpful video. after see this video i don't need to see other videos
Bhaiya aapke jaisa aaj tak koi nai samjha paya thanks bahut ache se ghus gaya dimaag mein
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
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 your really Great pahle aapne problem btayi fr solutions btyaa
Isse hume kaafi smjhne me asaani huyi
Vlookp is taraj abhi tak kisi ne nahi samjhaya.
Bahut khub
Thank you so much for the excellent explanation. God bless you.
your way of explaining things in excel is so easy
Thank you so much for your comment.
I have used vlookup many time but learned so well first time. thanking you sir 😇😇
Thank you for your comment.
Ap buhat acha samjhate hain sir ...
You explain this topic in very easy manner thankyou sir ☺️
Keep watching
Thank so much sir aapne bohut achese samjhaye maine first time aapki video dekhi very nice 🙂
Thanks lokesh ji its to easy to learn ....
again thank you so much
Aap pehle TH-camr ho jinho ne itne ache se samjaya
Thank you so much
Thanks Sir, I am 36 years old and I have been working for 16 years, But today I understood vlookup.
same
Sir bohot easy tarilke se explain kiya.
Nice Sir 👍
Sir , First of all , Thank`s for for the free Knowledge, Plz keep sharing Sample Date to practice by following video .
Thanku so much sir for the best video👍
Very easiest way of teaching ❤soo helpful thanku ❤️
Most welcome
सबसे बेहतरीन तरीके से समझाते। है sir आप।
Maine ye function aap se hi sikha h
Aap bahut achha samjate h sir
Thank you so much
Thankyou so much finally I have learned vlookup formulae from ur this video...really appreciated 👏👏👏
Thank you sir aapke samjhane ka Tarika lajawab hai
The way u Explain is Excellent,.
It was amazing that...I really appreciate the way u explained...Allah always bless u
It's my pleasure. Thank you so much.
Ap ke samjhane ka tareeka zabardast hai sir. 🎉🎉🎉
Yes really learning with LEARN WITH LOKESH LALWANI
Very informative 👍👍just impressed how you clear the minor details 👏
Thanks you so much for your comment.
Really you explain in a very simple and easiest manner, merey maan kaa daar nikal gaya for V look up
Great sir … totally understand
From Pakistan.....very help ful videos
Thanxalot
Sir aap bahut axa padhate hain aap Se request hai ki Aise hi Viedo banaye ❤❤❤
Sir bahut accha samajh aaya thnks sir
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 👍👍👍
The way u explain that was so easy, thanks, it will definatly help me in future.
Thanks Lokesh ji for this superb video. Very easy to learn from this video.
Such a nicely prepared video, complicated topic made by u very easy👍👍👍👍
Nicely communicated🙏
Thank you so much
V lookup samajh main aa gya sir, thanks
Itna simple tarike ke shayad hi koi sikha pyega sir! ❤
Good evening from Doha Qatar
I would like to grateful to make this useful video
Thank you so much
Glad it was helpful!
Sir I'm from Pakistan n I like ur way of teaching, really superb
Thank you so much for your comment.
Thanqu so much sir,, I finally learnt VLOOKUP......👍👍
Welcome 👍
thank u so much i was really facing problem because i was not knowing vlookup in detail , but after watching ur video i got that .
Glad to hear that
Aaj mai bilkul samaj gaya ....thank u so much
Ap k concept ar hindi/urdu kitni nice hai boss...,❤
Nice and comprehensively explained
Glad it was helpful!
Thank you sir for sharing this video and you way of explain really nice....
Sir you are genious....really mai bahaut a66e se sikh gaye details......kash aap mere computer teacher hote...😟
Your thech is best. Best learning video
Sir, बहोत अच्छेसे समझाते हैं आप, बहोत बहोत धन्यवाद 🙏🙏🙏
Thank you.
Lokesh ji i found your explanation method is best for each point in a clear way.
Hindi helps us to understand formula.
Thanks a lot
@@learnwithlokeshlalwani Pls take a look of this video, if u like it, pls share and Subscribe otherwise Thanks a lot for you valuable time... th-cam.com/video/NdT6Q1OQ8mQ/w-d-xo.html
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...
Thanku so much for such a detailed explanation...... Worthy watching ur videos
Thank you so much
Thank you bro for clearing all concepts.
Bahut jabardast tarika hai aapka thanx
Hello sir.. i am new to your channel. I just watched your video and after that i tried to use it and it's unbelievable in a single one attempt i do correctly.. because your explanation is very clear and easy to understand.Thanks you
Thank you so much for your comment. Keep learning!
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🙏🙏🙏🙏
Very good explanation... I understood and liked it
Guruji, you have explained it so well. This was problem for me, now in understand it. Thank you so much.
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
Pehli bar sahi se vlookup samaj me aaya sir thank you 😊.
Thank you sir bohot hi easy aur elaborate karke sikhaya aapne
Your video very helpful sir please continue your videos 👍