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.
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.
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.❤️🙏🏻🙏🏻🙏🏻
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
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 .🙏
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.
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.
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
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.
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?
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. 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.
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❤
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...
@@learnwithlokeshlalwani Pls take a look of this video, if u like it, pls share and Subscribe otherwise Thanks a lot for you valuable time... ua-cam.com/video/NdT6Q1OQ8mQ/v-deo.html
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 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 🙂🙂🙂🙂
Dear Awesome! i went through many videos but most of videos has not interduce the fact that, data can be checked only if it exists on right side for the common data, Great Job Dear
![vlookup in excel | 5 Types of vlookup | excel interview questions [Hindi] #vlookup](http://i.ytimg.com/vi/KJ8jFCsZB2Y/mqdefault.jpg)
![vlookup in excel | 5 Types of vlookup | excel interview questions [Hindi] #vlookup](/img/tr.png)
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
@@learnwithlokeshlalwanibahi ji thoda dheerey batayin na mujhey to kuch samjh mai nehi aya
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.
समझाने का तरीका काफी अच्छा है
Yes ajtak koi bhi video maine is tarah simple tarike sena hi samza ...Bahot badhiya
समझाने का तरीका बहुत ही आछा है ।Thanks
You are such a best teacher sir .....Maine aaj pheli baar aapki video dekhi hai aap bahot accha smjhate hai.
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 🥰🥰🥰
Owsum explain for vlookup excel sheet .....Isse behtar or koi explain nai kar Sakta ....so easy thanku sir
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.
Vlookp is taraj abhi tak kisi ne nahi samjhaya.
Bahut khub
You don't know how much this video has helped me. Thank you so much.
Aap pehle UA-camr ho jinho ne itne ache se samjaya
Thank you so much
samjhaane ka tareeka achha hai. Subscribed.
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
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
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
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...
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
I just want to say that this is the best video ever for vlookup thank you so much for giving this information 😊
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.
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.
Perfectly explained...vry much useful to clear the doubts in this topic. Thanx
ua-cam.com/channels/dY5JUg4SU4O3-bEqgkbh1Q.html
Sir your really Great pahle aapne problem btayi fr solutions btyaa
Isse hume kaafi smjhne me asaani huyi
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
Lots of respect and appreciation from Pakistan. Only you make excel look way easier. Hats off to you !
Thank you, Sir!! Specially for telling us about that it doesn't work on LHS, till date i wasn't aware
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
Thank you for this clear explanation! The Vlookup function is very useful, particularly in large datasets I frequently work with 😊
Yes really learning with LEARN WITH LOKESH LALWANI
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.
1st time on youtube who are really amazing man, that deliver right stuff to understand with easy way.
Thanks
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
Sir apka samjhane ka tarika bahut achcha hai . Excel se related sari problem ko achche solve kiya jata hai. Thanks 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 😊😊😊
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. 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!
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
बेहतरीन प्रस्तुति, आपसे निवेदन है कि ऐसे एक practice sheet भी अपने लिंक में जोड़ दें, आपकी वीडियो काफी असरदार हो जायेगी।
Bhaiya aapke jaisa aaj tak koi nai samjha paya thanks bahut ache se ghus gaya dimaag mein
Sir you are genious....really mai bahaut a66e se sikh gaye details......kash aap mere computer teacher hote...😟
Thankyou so much finally I have learned vlookup formulae from ur this video...really appreciated 👏👏👏
Ap buhat acha samjhate hain sir ...
Thanks Sir, I am 36 years old and I have been working for 16 years, But today I understood vlookup.
same
Thank you so much for the excellent explanation. God bless you.
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
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.
Sir, बहोत अच्छेसे समझाते हैं आप, बहोत बहोत धन्यवाद 🙏🙏🙏
Thank you.
Itna simple tarike ke shayad hi koi sikha pyega sir! ❤
I have used vlookup many time but learned so well first time. thanking you sir 😇😇
Thank you for your comment.
Really you explain in a very simple and easiest manner, merey maan kaa daar nikal gaya for V look up
Ap k concept ar hindi/urdu kitni nice hai boss...,❤
Sir bohot easy tarilke se explain kiya.
Nice Sir 👍
VERY GOOD VIDEO, GAGAR ME SAGAR HAIN YE VIDEO.
Sir aap explain bohut correct karte ho
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...
सबसे बेहतरीन तरीके से समझाते। है sir आप।
Ap ke samjhane ka tareeka zabardast hai sir. 🎉🎉🎉
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... ua-cam.com/video/NdT6Q1OQ8mQ/v-deo.html
Sir I'm from Pakistan n I like ur way of teaching, really superb
Thank you so much for your comment.
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 u so much sir for very simple way to learn VLOOKUP...
From Pakistan.....very help ful videos
Thanxalot
Sir your voice is very clear for explaining
Aapka Explanation bohot hi acha hai sir
Maine ye function aap se hi sikha h
Aap bahut achha samjate h sir
Thank you so much
Sir aap bahut axa padhate hain aap Se request hai ki Aise hi Viedo banaye ❤❤❤
Thanks Bhai bht kuch shikne ko mila apki vidio se🙏🙏🙏🙏
You explain this topic in very easy manner thankyou sir ☺️
Keep watching
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
Thank so much sir aapne bohut achese samjhaye maine first time aapki video dekhi very nice 🙂
Your thech is best. Best learning video
Very easiest way of teaching ❤soo helpful thanku ❤️
Most welcome
The way u Explain is Excellent,.
Bahut achcha bataya aapne, concept clear
Glad it helped!
your way of explaining things in excel is so easy
Thank you so much for your comment.
First time I saw this video. It was really amazing. Keep uploading such videos. Thank you
Thank you, I will
Very informative 👍👍just impressed how you clear the minor details 👏
Thanks you so much for your comment.
Thanks Lokesh ji for this superb video. Very easy to learn from this video.
Sir , First of all , Thank`s for for the free Knowledge, Plz keep sharing Sample Date to practice by following video .
Very interesting class.... many Thanks for giving this lesson
u r teaching skills is very good sir...😍
Very helpful video. after see this video i don't need to see other videos
Very good explanation... I understood and liked it
Thanks lokesh ji its to easy to learn ....
again thank you so much
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.
Pehli bar sahi se vlookup samaj me aaya sir thank you 😊.
Love the way you explained🤝
Thank you sir aapke samjhane ka Tarika lajawab hai
Thank you sir bahut hi acchi tarah samjhate hain aap
Dear Awesome! i went through many videos but most of videos has not interduce the fact that, data can be checked only if it exists on right side for the common data, Great Job Dear
Thank you.
Clear and very precise- easy to understand
Amazing video.... You have made VLOOKUP so easy
Thanqu so much sir,, I finally learnt VLOOKUP......👍👍
Welcome 👍
Aaj mai bilkul samaj gaya ....thank u so much
Thank you so much sir... You have cleared my all doubts ....
Such a beautiful video for new learner..
Thanks a ton for creating this video.
Thank you so much for explaining it in simple way, now i can use Vlook without any issues.