Love this video!!! Preparing for an Excel test for an HR internship. Thank you so much for posting and being EXCITED about teaching Excel! Thank you so much!!!!!
Hello! Thank you so much for helping us with these valuable training videos. I'm applying for a job (after being unemployed for almost a year) and it requires some knowledge in vlookup and pivot tables. Please keep teaching and God bless you!!
Thank you very much for your explanation. I have tried a number of excel courses but have found your lessons much more practical and helpful. Thank you again.
@Slyonethegreat You have to enter the column number from which you want the data to be retrieved =VLOOKUP(A1:A2352,G1:G2600,2,0) . In the video i have numbered the headers , watching the video once again may solve the issue for you. Also i liked your video game video on your channel.
Thank you very much for explanation. Please clarify me whether I can use IF function while picking up values using VLOOKUP. Ie., where we give column index number? My issue - I have two or more different values in index column for one lookup value. In such cases VLOOKUP is picking only the first value in the index column. But I want all values for each LOOKUP VALUE . Thanks in advance.
It was great man.. I have easily learned..but I have one doubt..how had you done the copy thing of the result which you have had in the last of the video.. would you please tell me this..
Good Sir, this was very easy to understand, and you provided a lot of good information in a short amount of time, with good step-through examples! Great job!!!
Sir Thanks for sharing valuable V lookup video, but I am trying to search link which is given on above excel sheet but I am not able to find please advise
Hi sir I completed btech and i have experience in logistics filed and e-commerce ..so please suggest me about excel cource which make me perfect in excel ..if any SAP cource also which is useful for me Thanks
hi!! thanks you and congratulations on your video!! I am trying to use vlookup and I keep getting an error, i have checked and checked for an error in the syntax, but it´s perfectly correct... any ideas as to what could be happening??
Sir, its a great training.. generely i previously i dont know what is vlookup and how to apply it. i searched alot in internet. but the maximum person use the shortcuts. i want to know the basics from the root. then i foud ur video , truly its amaizing.... i 'm gonna subsribe ur chanel. thanks for sharing this knowlege with us.. and sorry for my bad english :D
Supper boss... But I would like to know that how yo vlookup form another file data into another file??? Please tell In my lap not coming full formula showing... And not coming...
I have made around 10 videos about Vlookup and they cover what you are asking. In fact 1 such Vlookup video was published a few days ago. Please search the videos on my channel and I am sure you would find it
this is very useful. I have request for you that can provide Interview tips for the person who looking job in BPO sector. I knew you have the enough knowledge of that also. Thanks
Love this video!!! Preparing for an Excel test for an HR internship. Thank you so much for posting and being EXCITED about teaching Excel! Thank you so much!!!!!
+David Repovz Welcome and best of luck my friend : )
I'm sorry but i don't understand better because of your accent. But it was good
Hello! Thank you so much for helping us with these valuable training videos. I'm applying for a job (after being unemployed for almost a year) and it requires some knowledge in vlookup and pivot tables. Please keep teaching and God bless you!!
Welcome Brenda. Wish you best of luck for your new work life.
You're the first person that actually explains it so it makes sense, THANK YOU!
Thanks 😊 for making it easy to understand
The best Vlookup video I’ve ever came across. Thank you so much. 🙏🏽🙏🏽🙏🏽❤️
Thank you very much for your explanation. I have tried a number of excel courses but have found your lessons much more practical and helpful. Thank you again.
I was always confuse about col_index_number... but u made it very easy...Very helpful video...thanks
An excellent, simple lesson , you are great teacher .
This is really helpful guys..I was a beginner & learned watching all his videos
Thanks for sharing your wonderful Excel knowledge !!!!
+Mohammed Arif Pasha Ali Welcome : )
Your videos are providing employment to different peoples who are not that confident to face such situation..really good work Guru!!. Thank you!
@Slyonethegreat You have to enter the column number from which you want the data to be retrieved =VLOOKUP(A1:A2352,G1:G2600,2,0) . In the video i have numbered the headers , watching the video once again may solve the issue for you. Also i liked your video game video on your channel.
very helpful thank you for helping me to understand a better way to array formulas in excel!
This is one of the best tutorial videos for beginners
This guy just saved me life! Thank you so much . You got a new subscriber!
Welcome
Thank you very much, you made me understand this like no one before.
Thank you! Very simple explanation.
Very useful video . Had a question. I am trying to use vlookup to copy emails but am unable too. Can u plz guide ?
Thank you very much for explanation. Please clarify me whether I can use IF function while picking up values using VLOOKUP. Ie., where we give column index number? My issue - I have two or more different values in index column for one lookup value. In such cases VLOOKUP is picking only the first value in the index column. But I want all values for each LOOKUP VALUE . Thanks in advance.
Very nice and useful video. Thanks for spreading the knowledge.
I have been confused for 20 years until now. Thank you.
Woow😂😂😂😂
It was great man.. I have easily learned..but I have one doubt..how had you done the copy thing of the result which you have had in the last of the video.. would you please tell me this..
thank you, it is very easy to understand your teaching.
Awesome knowledge very simple . I love your way of teaching practical approach.
This was a brilliant demo and very well explained. thank you
best part of the video is your dialogue 'answer aa gaya' i loved that humour and immediately correcting urself
Thanks Ms Sarkar
is it appropriate to ask for ur email
This will definitely help in my new job. Thanks for the tutorial. Subscribed.
THANK YOU SO MUCH FOR THIS INFORMATION,IM BEGINNERS BUT i learn a lot today,,
Very clear instruction , thumbs up !
Thank you so much, you teach well and it's so easy to follow.
Thank you so much for this wonderful explanation and sharing the video. Could you please share the link for hlookup ? I am not getting it.
Thank you! I needed this. Easy to follow and Fast...
lashara10 Welcome : )
Thank you !!!!! You saved my energy and time ❤️
This was the only video I found that actually made sense! Thank you for keeping it simple :)
Thank you
Good Sir, this was very easy to understand, and you provided a lot of good information in a short amount of time, with good step-through examples! Great job!!!
Thanks, It's a nice lesson to learn 'Vlookup' in Excel.
+ashraf khan Welcome :) You can watch all my videos on www.myelesson.org
myelesson made me to understand the concept of excel clearly and easily
Welcome Dear.
This video is ridiculously helpful. Thanks a mill!
THANKS FOR YOUR TEACHING OF VLOOKUP~!!! EASY TO UNDERSTAND~
MAN WAI KWAN You are welcome : )
I love what you said, share the knowledge
Love this video. Great, easy to understand video. This translates very nicely to more advanced videos
love that spontaneous Answer Agaya :D thank you @My E-Lesson
even after years this guy is still helping hundreds if not thousands of confused students
Sir Thanks for sharing valuable V lookup video, but I am trying to search link which is given on above excel sheet but I am not able to find please advise
Hi sir
I completed btech and i have experience in logistics filed and e-commerce ..so please suggest me about excel cource which make me perfect in excel ..if any SAP cource also which is useful for me
Thanks
You 're good! I was practicing at the same time and yes, I finally know what Vlookup is about. Thank you! Good job Teacher! :-)
Your really great, I really learnt in few minutes.. thank a ton
Welcome .
Very helpful and easy to understand. Great video
Best Excel Video WOW Boss U Rocks.. Simple and easy to learn
madan Thapa Thanks
Thank you! You are an Excel guru! Awesome job!! :) Very helpful!
Sir, excellent teaching, very easy way you're explaining!! Good keep it up
thanks for sharing your knowledge
AWESOME VIDEO.....ANSWER AAGAYA WAS THE BEST......
Very simple and good... Thank you
Thank you for this, helped greatly on my information systems assignments!
very easy to understand, thank you very much
very nice video presentation. very understandable thank u
Great...Helping nature..Great video and easy to understand
Thank you very much thank you and I love your tutorial like I do
Nicely explained, it's easy to understand ..Thank you !
Enjoyed your presentation and was very helpful, Thanks.
VERY NICE PRESENTATION!!!!
awesome video sir & its very useful thank you for share your knowledge
it is very good explaination and useful , i really liked it .thank you very much
Your voice is so nice... Teaching style is also.awesome
Hi,
Would this work if the names in your table are not placed at the same location in both sheets?
hi!! thanks you and congratulations on your video!! I am trying to use vlookup and I keep getting an error, i have checked and checked for an error in the syntax, but it´s perfectly correct... any ideas as to what could be happening??
Try checking the data range frmm where you are trying to lookup the data by pressing F2.
Very nice bro.I'm a freelancer and I like it.
That was short and useful, Thanks a bunch!
Answer aagaya bhai... txz for the video
i love itttttt. so helpful and your explanation is on point !!! very easy to follow and to comprehend ^^ !! thanks so much !!
Thank you making Vlookup simple to learn!
Perfect easily understandable video
thanks sir... simple and easy to understand....
Sir, its a great training.. generely i previously i dont know what is vlookup and how to apply it. i searched alot in internet. but the maximum person use the shortcuts. i want to know the basics from the root. then i foud ur video , truly its amaizing.... i 'm gonna subsribe ur chanel. thanks for sharing this knowlege with us.. and sorry for my bad english :D
Thank you looks easy the way you did it
thank you sir very much 4 sharing your knowledge,,,really thankfull 2 you.........
Thanks for the great tutorials.
Very helpful mate! Good job! Thanks
Your way of expressing is commendable sir 👍
Supper boss... But I would like to know that how yo vlookup form another file data into another file??? Please tell
In my lap not coming full formula showing... And not coming...
I have made around 10 videos about Vlookup and they cover what you are asking. In fact 1 such Vlookup video was published a few days ago. Please search the videos on my channel and I am sure you would find it
Very nice and helpful video
Its easy.. Thank you for the sharing.. God bless you..
very nice explanation.thank you
Dear sir your information and explanation is good 👍👍👌
Great video! Thank you very much!!!
such a nice video to learn vlookup easily....appreciate sir...
THANK YOU SO MUCH FOR YOUR EXPLANATION AND IT IS VERY USEFUL MY CAREER..
+susan thomas Welcome
VERY WELL EXPLAINED
You are the best of the best, thanks you help me a lot, very clear!!!!!!
Thank you.
Thanks Great Information.
Very helpful tutorial ever found!
Very happy to learn Vlookup
Very nice. The way you taught I felt very comfortable. Keep on sharing knowledge :)
Bro your video is better than many other. Thanks
+Benny Sebastian Welcome, please visit www.myelesson.org for more videos
this is very useful. I have request for you that can provide Interview tips for the person who looking job in BPO sector. I knew you have the enough knowledge of that also.
Thanks
nice video .......your voice is so clear and soft...
Wonderful i like they way you explain ...
good presentation with nice voice
This is very simple explanation. And i get it
Thank you sir it was a nice video and one more thing I would like to say you that your accent is as similar as American