I had to learn this for class and it was poorly explained by my professor, but this is slow paced, easy to understand, and reinforced! Subscribed! Thanks mate.
I watched 4 other videos. Where this made the largest difference was the identification of the table with its own name to avoid absolutes and voila!!! it worked. Really nice breakdown of the way the function searches the table for the data too - thank you.
Very clear and I liked the way you covered even the "TRUE" feature in Vlook up and where it may be useful. Thanks for taking your time in posting this tutorial...!
Finally, I understand the concepts. The instructor's delivery was easy-going and delivered the material in an easy to follow manner. Thank you very much!
Great Job!!!! Thank you very much! It's amazing how easy things can be if someone explains them in a good way. You made my day!!! I would have needed hours to understand this with my lecture slides only.
Thank you for taking the time to do this video. This is the best explanation of both Vlookup and Hlookup I have seen. Love the tip about naming the range which avoids using absolute ranges. Keep up the great work.
Fantastic tutorial!! I have a job interview for a finance position and using vlookups is a common skill they ask for. Now I can practice a little and say I know how to use them at a basic level. Thank you very much!
So informative! I found your steps extremely helpful. Other places I searched explained the gist of it, but seeing your tutorial made it clear why naming a table is important. I wasted so much time trying to find how I could extend the VLOOKUP cells while retaining the reference table. I'm explaining it badly, but through naming the reference table like you said, it went very smoothly. Thank you so much!
Thank you so much for this wonderful explanation. It was my first attempt towards understanding V and H Lookup and you made it look so very easy! Cheers!
Thanks, a lot for the tutorial, I tried it in a typical case I have, but it doesn't work when I choose exact value, returns N/A, and when I choose approximate value, it gives me output, but wrong , and even the same for different looked up value.....appreciating if you can help me
Hi Mike, this is an amazing tutorial and it seems to be what I am looking for. But the only thing is that I need the VLOOKUP on the example after 12min (using TRUE at the end to check the approximate) to give me the next higher number result not the lower. How do I do that?
Hi Mike, I figured out the problem, I was looking vertically in the rightmost column (Column 1), that is why, it doesn't work, when I moved the left, so it is now column 2, it works, thanks
If you mean my mini training course about Absolute cell references, it's free and all you need to do is sign up to my newsletter via theexceltrainer.co.uk
+bakyt izatova The items in the first column of the pivot table must be in ascending order (ie A-z or 0-9) so for example: 100, 200, 300, 400, 500 If I was looking up 299, Excel says "Is 299 equal to 100? No. Is 299 greater than 100? Yes. So it continues down the list. Is 299 equal to 200? No. Is 299 greater than 100? Yes. So it continues down the list. I s 299 equal to 300? No. Is 299 greater than 300? NO. So it stops and goes back up 1 row to 200 - and that is the answer.
@ 17:29 the value of cell C8 must be 700 pounds instead of 500 pounds because in the bonus details or the feedback table it is given that for 85% it is 500 pounds and for 90% it is 700 pounds and we are using TRUE function which is especially used for approximate results, so what is the logic behind it?? PLZ REPLY ASAP
Hi Yashjain. The value in C8 should be £500 because although 89 is close to 90 than it is to 85 (and therefore 89 is more approximate to 90 than 85), the TRUE parameter means closest to but NOT greater than so although 89 is closest to 90 it is not greater than 90.
First I would like to thank you for this helpful tutorial. 1) How do you make Microsoft Excel to auto-save like yours? 2) True or False, they are still confusing me. 3) What does N/A means? Once thank you, sir!
@Chris. I'm glad you found the video helpful. To answer your questions... 1. Excel is not autosaving. It may appear so from the editing of the video, but I manually saved although there is an autosave option via File > Options > Save. You set the save interval (eg every 10 mins) 2. False means that the text/number/date being looked up (ie first parameter in the function) must exist exactly in the first column of the lookup table. If it does not find an exact match, the answer to the function will be NA (that answers your Q3). So I would use False if I was looking for, for example, a specific employeeID in a list of ID's. True means that text/number/date being looked up (ie first parameter in the function) does not have to exist exactly in the first column of the lookup table. For this to work, the items in the first column of the lookup table must be sorted in ascending order. Watch the video again for an example of using true
Hi Laurence. The items in the first column of the table must be in ascending order only if you are using TRUE as the 4th parameter. If you are using FALSE, they don't have to be in order.
I stopped adding content to this channel in 2018. This is where you can find my Excel content now: th-cam.com/users/mikethomas67
I had to learn this for class and it was poorly explained by my professor, but this is slow paced, easy to understand, and reinforced! Subscribed! Thanks mate.
I watched 4 other videos. Where this made the largest difference was the identification of the table with its own name to avoid absolutes and voila!!! it worked. Really nice breakdown of the way the function searches the table for the data too - thank you.
Very clear and I liked the way you covered even the "TRUE" feature in Vlook up and where it may be useful. Thanks for taking your time in posting this tutorial...!
Finally, I understand the concepts. The instructor's delivery was easy-going and delivered the material in an easy to follow manner. Thank you very much!
Thank you Laura :-)
Great Job!!!! Thank you very much!
It's amazing how easy things can be if someone explains them in a good way.
You made my day!!! I would have needed hours to understand this with my lecture slides only.
Thank you for taking the time to do this video. This is the best explanation of both Vlookup and Hlookup I have seen. Love the tip about naming the range which avoids using absolute ranges. Keep up the great work.
Super tutorial! Thank you very much. If only expensive courses out there explained the topic as clearly as this!
Glad I came across your tutorial on the VLookup and HLookup, best explanation I've seen in comparison to my course study and the web. Thank you!
You are very welcome
I have struggled with this so much in class you have helped me to understand it perfectly.
You are welcome :-)
thanks for uploading, explain very clearly and slowly, easy to understand!
Great video! Learned to do VLOOKUP in under an hour!
A big thank you. The explanation really helped me a lot and I was able to learn really quickly. Thank you Mike.
You are very welcome
I give you Five star for great and easiest explanations
Thank you! I had a ICT GCSE practical exam yesterday & I aced it thanks to this video!
Fantastic tutorial!! I have a job interview for a finance position and using vlookups is a common skill they ask for. Now I can practice a little and say I know how to use them at a basic level.
Thank you very much!
+MrSupernova111 You're very welcome :-)
Nicely explained. You made it is easier than ever.
Thanks so much, this is by far the best explanation of VLookups for excel, on TH-cam :) Thanks, great help for my test tomorrow :)
So informative! I found your steps extremely helpful. Other places I searched explained the gist of it, but seeing your tutorial made it clear why naming a table is important. I wasted so much time trying to find how I could extend the VLOOKUP cells while retaining the reference table. I'm explaining it badly, but through naming the reference table like you said, it went very smoothly. Thank you so much!
Thank you for such a clear and in depth tutorial! I have subscribed☺️
Very nicely explained, thank you!
I could not learn these functions before, but now I learned very fast Thank you Mike.
Thank you for your wonderful explanation, will recommend everyone to view it.
Excellent clear and easy to understand vid. Much appreciated :)
Thank you so much for this wonderful explanation. It was my first attempt towards understanding V and H Lookup and you made it look so very easy! Cheers!
Amazing tutorial! The best i've ever seen!
Thank you so much for the training, u explained it very easy
Excellent tutorial! Very well explained and very easy to understand! Thank you so much!
excellent presentation , crystal clear. Thank you so much
Nicely explained. It really helped a lot.
Thank you so much for this tutorial.
Thank you so much it's very easy to learn in your way of explanation
Thank you!
very useful , many thanks from Egypt
Thank you so much for this useful video!! I understood lookups clearly!! :)
This is very easy and clear thank you!
Excellent! Great teacher.
Thank you very much. This was an awesome video.
Tanks this was extremely helpful!
Excellent tutorial!!!!
Very well explained.Thanks
Great video, many many thanks for sharing.
Brilliant Tutorial! very well explained and makes it really easy to understand. thank you :-)
Such a great tutorial. Got it straight away. Thank you :)
Thanks for your explanation on the approximate match. Btw, I found that it will still work if choosing the table array including its column header.
Very helpful. Thanks for that!
Great tutorial! Thank you!
Thanks mate, you're a boss. Subbed straight away👍🏾👍🏾
I signed in only to like your video! thank you very much
Thank you , it is a very useful video.
Thanks a lot
Thanks, a lot for the tutorial, I tried it in a typical case I have, but it doesn't work when I choose exact value, returns N/A, and when I choose approximate value, it gives me output, but wrong , and even the same for different looked up value.....appreciating if you can help me
very well illustrated!
Thanks, Very Helpful... Ur teaching was great..
You just made excel great again! hahaha, In all seriousness though, thanks for this
Thank you for educating.
It cant get more easier than this !
Very nice tutorial. Thank you.
Hi Mike,
this is an amazing tutorial and it seems to be what I am looking for. But the only thing is that I need the VLOOKUP on the example after 12min (using TRUE at the end to check the approximate) to give me the next higher number result not the lower. How do I do that?
This is excellent... thank you very much
it is great...thank you so much for easy explanation ...great effort by you.
Thank you very much, you are very clear
thanks, very useful material
well done mike sir.... great work
Very good video, thanks. Very informative. Great explanations on the why things are done they way they are (example: false vs true)
Thank you dear you explain well.
Can you add the worksheet you are using?
Very good Mr. Mike,
Thanks for the same.
Regards,
Vijay.
Can you provide the excel document you worked through so we could follow along with your video?
Mark Balliet Drop me an email via the contact form on theexceltrainer.co.uk
woooow thumbs up great tutorial. thanks
Excellent.. very helpful..
thank u soo much ☺☺☺easyt to learn.
Hello
i had used it ,it work,i have a problem ,for some cell has N/A comment but the data should be found there ,some problem ?
Drop me and email via theexceltrainer.co.uk/contact-the-excel-trainer with more details.
Thanks.. Its very useful
Hi Mike,
I figured out the problem, I was looking vertically in the rightmost column (Column 1), that is why, it doesn't work, when I moved the left, so it is now column 2, it works, thanks
it helps me a lot thank you
thanks for this video can u plz give me your links for cells references Relative & absolute
If you mean my mini training course about Absolute cell references, it's free and all you need to do is sign up to my newsletter via theexceltrainer.co.uk
godsend! thank you very much. the only thing unclear is how does excel decide in case with approximate match which value to choose.
+bakyt izatova The items in the first column of the pivot table must be in ascending order (ie A-z or 0-9) so for example:
100, 200, 300, 400, 500
If I was looking up 299, Excel says "Is 299 equal to 100? No.
Is 299 greater than 100? Yes.
So it continues down the list.
Is 299 equal to 200? No.
Is 299 greater than 100? Yes.
So it continues down the list. I
s 299 equal to 300? No.
Is 299 greater than 300? NO.
So it stops and goes back up 1 row to 200 - and that is the answer.
Does this work on Mac application "numbers" or Mac in general?
Yes the VLOOKUP function works the same on Numbers and on Excel for Mac
I don't understand how you named the table benefit list?
nice sir...
thanks or giving this information.
Thanks.. u r better than my boss ;)
@ 17:29 the value of cell C8 must be 700 pounds instead of 500 pounds because in the bonus details or the feedback table it is given that for 85% it is 500 pounds and for 90% it is 700 pounds
and we are using TRUE function which is especially used for approximate results, so what is the logic behind it??
PLZ REPLY ASAP
Hi Yashjain. The value in C8 should be £500 because although 89 is close to 90 than it is to 85 (and therefore 89 is more approximate to 90 than 85), the TRUE parameter means closest to but NOT greater than so although 89 is closest to 90 it is not greater than 90.
Please provide sample data you've used for practice!
Sorry I am unable to provide sample data for this video
+Mike Thomas It's okay... Thanks for such wonderful explanation being a non excel user...I could understand it very easily
i thought vlookup & hlookup are hard to learn but thanks to you sir.
thans a lot mike thomas
thank u soo much☺☺☺☺.
very helpfull. Gracias
Thank you so much
Very helpful...tq
awesome tutorial dude! Does it work with just one percentage value?
+Howard Trott Yes you could have just one percentage value. If you need help drop me an email via the contact form on theexceltrainer.co.uk
+Mike Thomas Thank you mike Boy do need help
Excellent Tq
Thank you
so helpful
God bless you.
thanks a lot
thanks!
good one
Awesome :)
Damn... thanks man... really helped
First I would like to thank you for this helpful tutorial.
1) How do you make Microsoft Excel to auto-save like yours?
2) True or False, they are still confusing me.
3) What does N/A means?
Once thank you, sir!
@Chris. I'm glad you found the video helpful. To answer your questions...
1. Excel is not autosaving. It may appear so from the editing of the video, but I manually saved although there is an autosave option via File > Options > Save. You set the save interval (eg every 10 mins)
2. False means that the text/number/date being looked up (ie first parameter in the function) must exist exactly in the first column of the lookup table. If it does not find an exact match, the answer to the function will be NA (that answers your Q3). So I would use False if I was looking for, for example, a specific employeeID in a list of ID's.
True means that text/number/date being looked up (ie first parameter in the function) does not have to exist exactly in the first column of the lookup table. For this to work, the items in the first column of the lookup table must be sorted in ascending order. Watch the video again for an example of using true
It has to be in from A to Z order or it won't work.
Hi Laurence. The items in the first column of the table must be in ascending order only if you are using TRUE as the 4th parameter. If you are using FALSE, they don't have to be in order.
make more videos