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
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..!
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...
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. 😀
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
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.💜
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.
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
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
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...
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.
Here is a short story about me just few minutes ego my Manager had given some work where I had to do some data segrigation. I was struggling badly then I saw this video and i completed the work. Thank you sir for this video. If anyone can describe Vlookup this was the most easiest one.
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❤
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.
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.
Just because of your one point that our column should be in the extreme left my formula got corrected otherwise I have 2-3 values but unable to apply the same . Thanks for sharing mistakes that we do while applying a formula.🙏 Thanks sir
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
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...🙏🙏🙏
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..............*
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 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❤
Seriously sir I must say the way u explained I have never learned things so easy u made it so easy for me seriously hats off for your efforts keep up the good work, thanx once again.
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. 👍👍👍
Hi, I am learning MS Excel now, which exam i need to take firstly on excel to get certificate from microsoft since there are excel courses with same code, could you please suggest me which exam I need to take firstly on excel since I am a beginner
Really Appreciate your lecture, Training, and way of teaching, which are most important for all who want to grow & improve their life, especially VLOOKUP.
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...
Mind blowing sir Doubt Sir vlookup approx match mein dekho apke values right corner mein hai apne bola tha left mein honge to value ayegi.. To right mein kaise..?
very informative video i searched on many channel but the way you explained 3-4 time in different manner was amazing. would also like to know how to make invoice in excel if already shared please share the link it is very important for me.
I love the way you teach which is making this video exciting. I learnt everything you taught in this Video. Thanks Mr. Arora. And please make some video for "what kind of work business Analysts does using excel"'.
You are an Excellent Teacher on TH-cam. It is very important for every student to learn from you. I like your Teaching video. Excellent training method.
love this video got to understand it well. but when u explain it maybe u forgot to say put , (coma) when u put the formula. the explaination is superb. understand it completely
Namaste, nicely explained. Qq, I have data say in Colmn 1 as Ram till ten rows and against each row in column 2 I have different data say Lakshman, next row is Sita, third row it’s Hanumnan and so on till 10 rows. When I am running a V lookup the data fetched is pickin the data in the first row in column one ie Lakshman. It’s giving me the same value Lakshman for 10 times. How can I fix this?
Sir, very easy to understand good job thanks for all your help because next week there is my interview and they will ask about excel and accounts..so thank you👍🏻
![vlookup in excel | 5 Types of vlookup | excel interview questions [Hindi] #vlookup](/img/n.gif)
🔥 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
video starts from 03:84, thank me later.....
Thankyou
03:48 aactually
Thanks 😂
Me watching ur comment after watching full video 😢
@@rutvikjani5154😅
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
Finally is vedio ko dekh kr seriously samjh m aya vlookup itna asan h.....this is it
Yes.. same here
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.
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
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
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...
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. 😀
Extremely nice explanation. It cleared all of my doubts..
Thank you very much for his wonderful contribution in society !
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.
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.
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
The way of u teaching us , its really very interesting and easy to learn 👏
बहुत अच्छा विडीओ बनाया है भैया आपने!
इस विडीओ से सीखने को मिला।
Easy to Learn, Easy to Understand and Fun while learning, keep going Sir, thank you.
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.💜
Awesome tutorial, thanks for sharing. Your way of teaching is very interesting
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.
I think u should also give the link of data on description for our practice .
That will be more beneficial for us
agree
At 29:43 I loved it....it's too funny and superb. Keep it up bro...comedy timing sense is awesome🤣🤣🤣🤣😂😂😂😂😅😅😅😅
Thank you so much sir...your classes are helping me a lot to learn excel in the proper way and gain some confidence🙏
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
Much awaited video of the whole excel series!!! Thank you so much sir!❤️
More to come. Thanks. Please share with all.
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
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
Professionals(CA, CMA, CS) logo ki baat kuch alag hoti hai... Very sir
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...
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.
I don't think I will ever forget the learnings from this video
Did u still remembered this formula ?
Here is a short story about me just few minutes ego my Manager had given some work where I had to do some data segrigation. I was struggling badly then I saw this video and i completed the work. Thank you sir for this video. If anyone can describe Vlookup this was the most easiest one.
What a teacher🔥 i love the way you teach us🤗
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❤
Nicely presented and elaborated. Well done Indev . Keep it up 🌼🌼🌼
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.
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.
Just because of your one point that our column should be in the extreme left my formula got corrected otherwise I have 2-3 values but unable to apply the same . Thanks for sharing mistakes that we do while applying a formula.🙏
Thanks sir
This is great package of excel , sir... love you
Ery good sir bank ke liy best
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
awesome explanation. till now i was always afraid of vlookup, but now you have made it so simple . Thanks a billion...
Thank you, explained in such a beautiful way. Easily understood 👍🏼
बहुत ही अच्छे से समझाया है आपने। धन्यवाद गुरु जी
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
Very Very Good teaching. Very Very interesting to listen your voice always. 🙏🙏🙏👍👍👍💯💯💯🌹🌹🌹
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...🙏🙏🙏
Learning start from 3:58
🙏🏻❤️
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..............*
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 😂
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 I want all questions of excel for practice if it's available so pls revert me
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❤
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 🙌
Appreciate 👍 @itrawadas
Appreciate
True
Thank you sir....my all doubts of vlookup are cleared and now I'm all set about vlookup
3:50 skip
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
awesome class sir alot of people around me told that working on excel is so much tough but when I start learning it from you I lov it :)
Great,,has been explained in a theroitical way,,,genuinely can't be founded on TH-cam by another one same way of teaching.
Sir apka padhaya poora samjh me aaya bahut accha laga it' s made me fan of you in Excel.
Thankyou sir
Thank you sir mene kafi videos dekhi h excel se related but apke samjhne ka tarika bahut achha hai....
Seriously sir I must say the way u explained I have never learned things so easy u made it so easy for me seriously hats off for your efforts keep up the good work, thanx once again.
Sir Video zoom kar k samjaya kary
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. 👍👍👍
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 🙏🙏
Thank you sir . Good information. I have question. Can just highlight the data from the lookup range instead of getting the value?
Hi, I am learning MS Excel now, which exam i need to take firstly on excel to get certificate from microsoft since there are excel courses with same code, could you please suggest me which exam I need to take firstly on excel since I am a beginner
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.
Sir, very easy to understand, nicely explained, and humorous too which is nice for the learning process.
Thank you sir for sharing your awesome tutorial, you make us. Understand in a very easy way. Please keep sharing you videos
It is very useful sir.. 🎉
really Sir first time i tried to learn Excel nd by seeing your vlookup video you make excel as like ABCD awesome Sir
Really Appreciate your lecture, Training, and way of teaching, which are most important for all who want to grow & improve their life, especially VLOOKUP.
Thank you very much for the video I was doing mistake at 17:24 in actual environment and was frusted why it showing NA now got answer .
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...
Awesome vedio sir.
According to my personal opinion, it's one of the best vedio in TH-cam channel.
Mind blowing sir
Doubt
Sir vlookup approx match mein dekho apke values right corner mein hai apne bola tha left mein honge to value ayegi.. To right mein kaise..?
Maza aa gya. Awesome video. Thank you very very much sir ji
Thanks for the video. Very useful and very well explained
very informative video i searched on many channel but the way you explained 3-4 time in different manner was amazing.
would also like to know how to make invoice in excel if already shared please share the link it is very important for me.
I love the way you teach which is making this video exciting. I learnt everything you taught in this Video. Thanks Mr. Arora. And please make some video for "what kind of work business Analysts does using excel"'.
😘
Trust me, I learned a lot things from this video. Am really thankful to you.
You are an Excellent Teacher on TH-cam. It is very important for every student to learn from you. I like your Teaching video. Excellent training method.
I found this channel very late but it's really helpful for me.... Thank You So much SIR for this wonderful explanation and guidance :)
love this video got to understand it well. but when u explain it maybe u forgot to say put , (coma) when u put the formula. the explaination is superb. understand it completely
29:43 pai to maza hi aagaya.......luv u sir
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!!
Sir Apki video ko dekhkar bohot achee se samaj me aya hi vlookup formula 🤗🤗👍
What an entertainment to learn vlookup, awesome! Thank you very much!! Mazza aa gaya bhai sahab!!
Dude You are The Great 👏
No one else could have taught me this better than you, Thanks a ton 👍
Jai Hind 🕉️🇮🇳
Namaste, nicely explained.
Qq, I have data say in Colmn 1 as Ram till ten rows and against each row in column 2 I have different data say Lakshman, next row is Sita, third row it’s Hanumnan and so on till 10 rows. When I am running a V lookup the data fetched is pickin the data in the first row in column one ie Lakshman. It’s giving me the same value Lakshman for 10 times. How can I fix this?
now i realized, why freezing is compulsory! Thank you for this video sir!
Much Explanatory and Extremely nice explanation along with Errors
Amazing video and keep growing and teach us as well ❤💯
Thanks sir , vlookup samjhne ke liye , aaj se pehle bhot confusion hota h formula bhul jate the but ab nhi bulenge
Sir, very easy to understand good job thanks for all your help because next week there is my interview and they will ask about excel and accounts..so thank you👍🏻
Sir, Good Job. 💯☺☺☺
Realy , such m itne asan tarike s kisi n nhi samjaya
Bht saal se pareshan tha .
Vlookup ratt liya tha but samajh nhi aaya tha.
Aaj samajh aa gya..
I interested for complete course
honestly you r great...may you prosperous more...respect and love from Pakistan
EXCELENT WAY OF EXPALANATION Thanks for sharing your knowledge
I used this method in data with thousand entry, n it work great in that. Thank you 🙏
Very nice way of teaching.. Easy to learn & understandable.. Thanks