Thanks alot! Im going to have my final ICT exam today, then im leaving high school. Doing some last minuite revision just in case. This makes it seem easier
I'm a 58 years old woman, learning Excel to apply in my future business. I have to say this is incredible way to learn, very well explain, illustration are easy to follow, and the voice of Jimmy is clear to understand every single word, I hardly recommended to anyone no matter your age. Thanks you so much and keep the good work.
@@ephymaina725 What? A 58 yr old person can't have a future? Are you suggesting any one older than 50 should just sit home and wait to die? This woman had the mental and physical strength to be learning a new skill with a great attitude....saying what you said just showed how shallow and lazy you are...
Thank you teacher for this amazing lesson, all crystal clear - but I have a question here: Does the lookup value have to always be an ID? Can I lookup for Employee Designation, from your table, so it gives me their IDs as results?
This is fantastic. I am self taught with most things in excel and this was always a somewhat intimidating function. After watching this video, I feel like it is child’s play! I would like to see more with the approximate values on the last part of the formula vs exact. How can this be used and how does it determine what values to look for? Thanks!
There are many kinds of teachers and the best one, in my opinion, would be the one who has the talent of making the students understand the difficult lesson in a simple way. And that's totally what you're doing. I really enjoy your video content about excel. They are totally helpful. Thank you so much!
Thank you! I have a job interview coming up and the phone interviewer mentioned v look up. I just learned more about it from your 11 minute video than I did from my last semester of college. Nice.
Hope you will be fine. You have been working nicely. I have a humble request for you to make a complete playlist of Microsoft Excel from A to Z. It would be beneficial to learn excel completely.
Hi, Vlookup was something I dreaded learning because I thought it would be hard and I won't get it. After watching your video tutorial in this series. I feel more confident and I actually understand it!!! Thank you so much👏😌💚
So many years trying to understand this formula and finally in a few minutes you did the magic, now just going to practice this a lot to make sure it's embeded in my brain
Just want to let you know you are an awesome teacher, extremely articulate, informative, to the point and without fluff or rubbish talk which the majority of TH-cam presenters suffers from. I feel like I'm back at university again 😄. I hope you are well rewarded for sharing your wonderful knowledge which some of us barely get through paid tertiary education!
I would like to learn how to use V lookup and H lookup to find data from different sheets in the workbook and also conditional formatting with color change according to data changes.
current sheet A1:D6 different sheet named "Gandalf" Gandalf!A1:D6 thats how you reference it There is also the option to reference from another excel file entirely. File name "Magic.xlsx" C:\myfiles\[Magic.xlsx]Gandalf!A1:D6
Thank you for the tutorial! Your explanation is very clear and understandable. Loving all your Excel works, they are so helpful. Keep up the good work!
Wish I knew this formula last week. I'm self teaching right now and am leaning heavily on =if and =ifs. Probably could have taught it in less than 5. Still I went from not knowing it to using it in 8:21.
I'm a 77-year old student refreshing my Excel course from the '80's and really appreciate the clarity of teaching and explaining. Thank you for all of your videos. And I just discovered you on Facebook, too.
I think I have been missing a whole lot just working on Excel and not exploring other functions. Thank you, as you're making me a more efficient data person.
A little help. This video is perfect, but I have one question. I have set up a table with customers names and addresses. I have two separate columns for the street address as I ship to business all the time. An example would be 123 Butternut Lane, Suite 101, Garner, NC 27529. Having a second column for street address is not always filled in. Put simply it's blank. When doing VLOOKUP using a false statement it returns a zero. How do I get it to leave it blank?
Well explained. Thank you. Please explained about how can we get more than one outputs at one time. Mean, if we want to get eric's designation, team, and salary. is there any possibility? Regards,
Is there a way to use the Vlookup function to lets say type in the designation analyst and have it present the total salary paid to all analysts? How would I insert a sum function into vlookup? Thank you for your videos I'm learning a lot!
@Teacher's Tech. I had followed the VLookup formula rule for the example you had presented for the employee name and the employee designation it worked. When I tried to use the VLookup formula to get the results for Employee Code and the Employee Salary the results didn't work. Here what I used for the formula =VLOOKUP(I2,B2:F25,5,FALSE) and typed GOTE for the Employee Code the Employee Salary is not showing up It still shows #N/A. Also, when I changed the Employee Code to Employee Name and entered an Employee Name, the Employee Salary is displayed in the box. Can you please help me and let know what I am doing wrong? Thanks
This is a great short lesson! I have been taking an online course and reading about vlookup and hlookup and it wasn't clicking in my head but thanks to you it makes so much sense. thank you for breaking it down in a simple way. back to studying for me!
I want to be able to construct a formula that will calculate how much money I average per hour...hours worked vs daily salary. Any direction would be appreciated.
Thank you. This helped quite a bit. I download the data table so I could work with live data. I'm taking a survey course of Microsoft Office and I'm having some difficulty grasping this, constructing the function. Thank you, thank you, thank you. Big help. Plus I can go back over this.
I have heard of VLookup and HLookup, but didn't know how to do these. It helps to see this in a video. What version of Excel are you using? I tried this and it gave me either errors or a different answer not in the column it should have given me. I was using a list that I made to track some stocks.
Well done for your video. I enjoy listening to people who can explain complicated tasks in simple ways - and you certainly can do that. I'm subscribing. Cheers.
Important note: when you have a spreadsheet with a lot of columns: just make sure that the column with the lookup value is simply left of the column you want to search in. The Vlookup function can only search to the right! Good luck 😊
Always remember we must repent of our sins (sin is transgression The Law Of Yahuah The Father in Heaven. The Law are The Books: Genesis, Exodus, Leviticus, Numbers, & Deuteronomy). We must repent of our sins and Have Belief On Yahusha The Messiah. HE Died and Rose three days later so that we can be forgiven of our sins! Come to HIM🙂
Thank you for this. I’ve always had a hard time understanding vlookup but I think I finally got it. At least the basic understanding which is enough for now. Sincerely thank you.
I am doing MBA but I wanted to know excel well enough before my course. Can't describe in words how much grateful I'm finding this channel. Jimmy Sir you're an incredible teacher. Simple & to the point. Thank you so much for helping us all & teaching us❤❤
how can I take a column of data and then spit out either a list or somehow mark the answers, for adding an alternating set of numbers. Example: A column of 0 thru 20. I want to add 3 then 5. Each number gets added to the previous sum. 0+3=3, 3+5=8, 8+3=11, 11+5=16 etc. So I would get a list of 3, 8, 11, 16.
I don't know how I'm supposed to explain this on my zoom interview Tuesday if I'm asked about vlookups. smh Maybe I'll try to memorize what you said...kind of
I love how job descriptions have VLOOKUP as a requirement implying somehow that it's hard. It's so easy. I suppose for those with a programming background, it's a joke.
I'm not sure if your teaching style is better for older folk, and I say this in the nicest way possible, but you're driving me crazy going detail by detail blow for blow for the explanation. This video could be reduced to 5 mins max, making it more easy for a person to look up multiple functions and learn them without having to skip ahead in your videos. Thanks for the explanation though
Hello , i do whatever you say and it works actually but i have a problem. For example when ı type ''John'' it gives me the correct assignation of John which is Software engineer , but i type louis and it shows me Analyst however he is Lead associate, what can be the problem ? İ also tried it with true too but nothing changes.. Thanks for help
What I need help with is using your example, lets say you want to add a catagory code where employee code is, So if I want to add code# 101 to the left colume next o all Software Engineers and 102 next to Analyst how do I do this. I have a simular colume list but its over 500 namse and need to put catagory numbers for each designation. Its going to take me a week to go down the list and its not the exact names on each line so it still would be difficult to sort list by name and manually enter each line. example> Find all names that contain software and insert 101 where employe code column field next to that name . Thanks Bruce
I need to use the series function to autofill percentages. I have 4%, 8% and need to fill 12%, 16%, 20%, 24%, 28%. I cant seam to fill the 12 through 28.
Thank you for the video as it has refreshed my memories about the HLookup and the VLookup. Also, I have noticed that you have Ronaldo, Neymar, and Messi names on the list of employees. Are you a soccer fan? Those 3 names cracked me up and I have noticed a few others from other sports as well.
great tutorial. How would you tie those two Vlookup functions together? More specifically, enter an employee name and have Salary, Code, and Designation inputted automatically?
very pleasant to listen to, but for me he doesn't dumb it down enough. also, at my company, they use the fx formula box in the upper left, they don't type it. I will say, I did not know what the "v" stood for and now I do, so thank you. I need to know how to copy whole columns from another sheet/tab into another. will keep searching for vids. but, one of the easiest vids to watch and listen to I have come across thus far.
I need help. I run a baseball league and use basic excel stuff to track stats, rosters, etc. I’m trying something to make life easier. Can I use a master sheet with data and link that data to go into multiple sheets just by? Each team in the league has a tab for its players and salary. I wanted to use a master sheet with all the players and the players salary and link that to all the 24 team tabs. So if a trade occurs I could go to the master sheet with all the players just switch the teams in that sheet and it will then automatically swap those players in the individual team tabs. Is this possible?
Dude, why would you show us what shouldn't do while showing us what we are supposed to do? Can I make a suggestion? do a straight walk through of how to get from point a to point c with explanation of why you are doing each step, then go back and explain where people might make mistakes and other options to explain. Poorly made video!
Thanks alot! Im going to have my final ICT exam today, then im leaving high school. Doing some last minuite revision just in case. This makes it seem easier
I'm a 58 years old woman, learning Excel to apply in my future business. I have to say this is incredible way to learn, very well explain, illustration are easy to follow, and the voice of Jimmy is clear to understand every single word, I hardly recommended to anyone no matter your age. Thanks you so much and keep the good work.
same here, I've not used excel in a long time, going for interview this week, the video helps, thank you .
Who? Cares
*heartily (“hardly” conveys pretty much the opposite of what you meant)
future? you are 58!!!!!!!
@@ephymaina725
What? A 58 yr old person can't have a future? Are you suggesting any one older than 50 should just sit home and wait to die?
This woman had the mental and physical strength to be learning a new skill with a great attitude....saying what you said just showed how shallow and lazy you are...
If you were my calculus teacher in college, maybe my whole life would have turned out differently. 😉
Me too😭😂
He's great indeed.
You made me smile.
I have watched countless videos but for some reason it didnt click until watching your video. Thank you so much
love the video very simple and straight to the point. Please keep making excel videos and Thank You Very Much!
I subscribed to your Chanel recently. Your works are amazing!! God save you🙏
Thank you so much!
Fabulous about to go into an interview and haven’t done vlookup in years and you just might help me get a job! THANK YOU
Haha, I also watched this video to help my chances at a job interview
Me too! I have an interview tomorrow. 😁
Same
Your tutorial was the best one I have came across! Thank you!
Glad it was helpful!
Loving the GOT characters 😂
Perfectly explained! Thank you so much🙏🏽
So glad I found this video, super helpful! Thanks a bunch!
Thank you teacher for this amazing lesson, all crystal clear - but I have a question here: Does the lookup value have to always be an ID? Can I lookup for Employee Designation, from your table, so it gives me their IDs as results?
Great tutorial thank you so much!! This really helped me.
This is fantastic. I am self taught with most things in excel and this was always a somewhat intimidating function. After watching this video, I feel like it is child’s play! I would like to see more with the approximate values on the last part of the formula vs exact. How can this be used and how does it determine what values to look for? Thanks!
There are many kinds of teachers and the best one, in my opinion, would be the one who has the talent of making the students understand the difficult lesson in a simple way. And that's totally what you're doing. I really enjoy your video content about excel. They are totally helpful. Thank you so much!
Hey you shoulda mentioned Filters for people who need more than one result.
Thank you! I have a job interview coming up and the phone interviewer mentioned v look up. I just learned more about it from your 11 minute video than I did from my last semester of college. Nice.
Very helpful, thanks for your effort! Could you show how to do Vlookup using 2 sheets ?
Excellent tutorial.
Thanks
Love how Ronaldo, Messi and Neymar are there 🤣
Hope you will be fine. You have been working nicely. I have a humble request for you to make a complete playlist of Microsoft Excel from A to Z. It would be beneficial to learn excel completely.
Hi, Vlookup was something I dreaded learning because I thought it would be hard and I won't get it. After watching your video tutorial in this series. I feel more confident and I actually understand it!!! Thank you so much👏😌💚
So many years trying to understand this formula and finally in a few minutes you did the magic, now just going to practice this a lot to make sure it's embeded in my brain
Just want to let you know you are an awesome teacher, extremely articulate, informative, to the point and without fluff or rubbish talk which the majority of TH-cam presenters suffers from. I feel like I'm back at university again 😄. I hope you are well rewarded for sharing your wonderful knowledge which some of us barely get through paid tertiary education!
Wow, thank you!
Correct he is a Genious Teacher@@TeachersTech
Thank you so much!
I would like to learn how to use V lookup and H lookup to find data from different sheets in the workbook and also conditional formatting with color change according to data changes.
current sheet
A1:D6
different sheet named "Gandalf"
Gandalf!A1:D6
thats how you reference it
There is also the option to reference from another excel file entirely. File name "Magic.xlsx"
C:\myfiles\[Magic.xlsx]Gandalf!A1:D6
It is my first time learning VLOOKUP, and you have made it so easy to learn. You are awesome. Thank you very much. I had to subscribe.
Thank you for the tutorial! Your explanation is very clear and understandable. Loving all your Excel works, they are so helpful. Keep up the good work!
Simple yet effective! Love it
Thanks, I need to match employee number and birthday with their phone number. 2 different reports. It’s helped a lot!
You really break down the information in a simple matter, thanks for your teaching. I love your channel.
Wow! I had no idea this was so easy! Thank you for explaining it so clearly.
Glad it was helpful!
Wish I knew this formula last week. I'm self teaching right now and am leaning heavily on =if and =ifs.
Probably could have taught it in less than 5. Still I went from not knowing it to using it in 8:21.
Take your flowers buddy🌹🌹🌹🌹
Can you do a IF function your videos are so easy to understand it's really great
I'm a 77-year old student refreshing my Excel course from the '80's and really appreciate the clarity of teaching and explaining. Thank you for all of your videos. And I just discovered you on Facebook, too.
At this tender age of 77 why did you chose excel ..I mean have you tried skateboarding!?
Hey, this is great. I'm 68 and learning this, I learn something new everyday. God Bless.
stop the
cap🧢
I ll keep praying for you, thanks for simplifying this
You are so amazing, you are literally improving my computer skills.... Something that i should have been taught in HS thank u so much
I think I have been missing a whole lot just working on Excel and not exploring other functions. Thank you, as you're making me a more efficient data person.
Glad I could help you!
A little help. This video is perfect, but I have one question. I have set up a table with customers names and addresses. I have two separate columns for the street address as I ship to business all the time. An example would be 123 Butternut Lane, Suite 101, Garner, NC 27529. Having a second column for street address is not always filled in. Put simply it's blank. When doing VLOOKUP using a false statement it returns a zero. How do I get it to leave it blank?
Well explained. Thank you.
Please explained about how can we get more than one outputs at one time. Mean, if we want to get eric's designation, team, and salary. is there any possibility?
Regards,
This is sooo helpful for an older guy like me. Each step is articulated and explained, no one does this anymore.
Is there a way to use the Vlookup function to lets say type in the designation analyst and have it present the total salary paid to all analysts? How would I insert a sum function into vlookup? Thank you for your videos I'm learning a lot!
I also asked this question, where you able to get it?
Thank you so much
Love the ronaldo messi and neymar in there LOL but they make about that in 1 day
Nice. But you should say upfront what VLookup is for and what is the problem it is solving. I am a real beginner in this.
@Teacher's Tech. I had followed the VLookup formula rule for the example you had presented for the employee name and the employee designation it worked. When I tried to use the VLookup formula to get the results for Employee Code and the Employee Salary the results didn't work. Here what I used for the formula =VLOOKUP(I2,B2:F25,5,FALSE) and typed GOTE for the Employee Code the Employee Salary is not showing up It still shows #N/A. Also, when I changed the Employee Code to Employee Name and entered an Employee Name, the Employee Salary is displayed in the box. Can you please help me and let know what I am doing wrong? Thanks
Thank you so much sir, everything is broken down into very simple steps that is much more easier to follow.
Wow, impressive. I finally have a hand on VLOOKUP. Great explanation there
Glad it was helpful!
This is a great short lesson! I have been taking an online course and reading about vlookup and hlookup and it wasn't clicking in my head but thanks to you it makes so much sense. thank you for breaking it down in a simple way. back to studying for me!
Cheers! :)
would you be interested in doing a pivot tutorial level 2 ?
Great Tutorial, thank you kep up the good work . Blessings to you
.
Thank you - I have watched & read so many vlookup tutorials.....this one the best!
Can you use Vlookup with two separate tables, in one spreadsheet?
I want to be able to construct a formula that will calculate how much money I average per hour...hours worked vs daily salary.
Any direction would be appreciated.
Thank you. This helped quite a bit. I download the data table so I could work with live data. I'm taking a survey course of Microsoft Office and I'm having some difficulty grasping this, constructing the function. Thank you, thank you, thank you. Big help. Plus I can go back over this.
Excel's really intimidating, but you've simplified it so much that I genuinely feel like I'm learning. Thank you so much!
Excellent stuff
there is an error in your excel, ronaldo is the true GOTE
I have heard of VLookup and HLookup, but didn't know how to do these. It helps to see this in a video. What version of Excel are you using? I tried this and it gave me either errors or a different answer not in the column it should have given me. I was using a list that I made to track some stocks.
Really great tutorial, I am watching and liking all the details being discussed. Thank you
You took something that seemed complex, and simplified it. Thanks!
Your videos make excel user friendly! Could you help me with a formula that would find a specific word within a string of words (a sentence).
Well done for your video. I enjoy listening to people who can explain complicated tasks in simple ways - and you certainly can do that. I'm subscribing. Cheers.
GOATED THANK YOU
Great Tutorial, thank you. I’m interested in learning how to use vlookup on multiple sheets and mostly how to create a macro. Thanks in advance
I think it be good if you speak slower
Thanks a lot, I've been looking for a clear tutorial and here we are. Amazing job sir.
Important note: when you have a spreadsheet with a lot of columns: just make sure that the column with the lookup value is simply left of the column you want to search in. The Vlookup function can only search to the right! Good luck 😊
Always remember we must repent of our sins (sin is transgression The Law Of Yahuah The Father in Heaven. The Law are The Books: Genesis, Exodus, Leviticus, Numbers, & Deuteronomy). We must repent of our sins and Have Belief On Yahusha The Messiah. HE Died and Rose three days later so that we can be forgiven of our sins!
Come to HIM🙂
Thank you for this. I’ve always had a hard time understanding vlookup but I think I finally got it. At least the basic understanding which is enough for now. Sincerely thank you.
Can I download the same data so I can practice?
You are a life saver I couldn’t figure out why my command wasn’t working.
I have learned so much from your videos. Thank you!!
Thanks for sharing I have learnt a lot for my new job from your tutorials
Great to hear!
I lost a work´s test because I didn´t know this. I can´t believe it was this easy. Thank you!
Thanks for this! IT helped me learn VLOOKUP and you explained in a way that is easy to understand.
the messi ronaldo neymar is so slick 🤣🤣
I am doing MBA but I wanted to know excel well enough before my course. Can't describe in words how much grateful I'm finding this channel. Jimmy Sir you're an incredible teacher. Simple & to the point. Thank you so much for helping us all & teaching us❤❤
please i need some assistance, i keep getting wrong results even though my formula are correct for the vlookup
how can I take a column of data and then spit out either a list or somehow mark the answers, for adding an alternating set of numbers.
Example: A column of 0 thru 20. I want to add 3 then 5. Each number gets added to the previous sum.
0+3=3, 3+5=8, 8+3=11, 11+5=16 etc.
So I would get a list of 3, 8, 11, 16.
Thanks man, this combined with the data validation list is really helpful :)
Thank you for the clear concept. I have taken advanced excel classes and the teacher never explained it as easily as you have.
Thank you for making this so simple.
I don't know how I'm supposed to explain this on my zoom interview Tuesday if I'm asked about vlookups. smh Maybe I'll try to memorize what you said...kind of
Thanks a million mate , you are the best, you save me.
I love how job descriptions have VLOOKUP as a requirement implying somehow that it's hard. It's so easy. I suppose for those with a programming background, it's a joke.
Great teacher appreciate this video loads
I'm not sure if your teaching style is better for older folk, and I say this in the nicest way possible, but you're driving me crazy going detail by detail blow for blow for the explanation. This video could be reduced to 5 mins max, making it more easy for a person to look up multiple functions and learn them without having to skip ahead in your videos.
Thanks for the explanation though
Hello , i do whatever you say and it works actually but i have a problem. For example when ı type ''John'' it gives me the correct assignation of John which is Software engineer , but i type louis and it shows me Analyst however he is Lead associate, what can be the problem ? İ also tried it with true too but nothing changes.. Thanks for help
I Would like to see a video of index match in the future if possible
What I need help with is using your example, lets say you want to add a catagory code where employee code is, So if I want to add code# 101 to the left colume next o all Software Engineers and 102 next to Analyst how do I do this. I have a simular colume list but its over 500 namse and need to put catagory numbers for each designation. Its going to take me a week to go down the list and its not the exact names on each line so it still would be difficult to sort list by name and manually enter each line. example> Find all names that contain software and insert 101 where employe code column field next to that name . Thanks Bruce
I need to use the series function to autofill percentages. I have 4%, 8% and need to fill 12%, 16%, 20%, 24%, 28%. I cant seam to fill the 12 through 28.
Thank you for the video as it has refreshed my memories about the HLookup and the VLookup. Also, I have noticed that you have Ronaldo, Neymar, and Messi names on the list of employees. Are you a soccer fan? Those 3 names cracked me up and I have noticed a few others from other sports as well.
This was really helpful, thanks for this video! Very clear and and easy to follow
Thank you for including the practice files. These have been helpful to reinforce your lessons. Great job!
great tutorial. How would you tie those two Vlookup functions together? More specifically, enter an employee name and have Salary, Code, and Designation inputted automatically?
very pleasant to listen to, but for me he doesn't dumb it down enough. also, at my company, they use the fx formula box in the upper left, they don't type it. I will say, I did not know what the "v" stood for and now I do, so thank you. I need to know how to copy whole columns from another sheet/tab into another. will keep searching for vids. but, one of the easiest vids to watch and listen to I have come across thus far.
I need help.
I run a baseball league and use basic excel stuff to track stats, rosters, etc. I’m trying something to make life easier. Can I use a master sheet with data and link that data to go into multiple sheets just by? Each team in the league has a tab for its players and salary. I wanted to use a master sheet with all the players and the players salary and link that to all the 24 team tabs. So if a trade occurs I could go to the master sheet with all the players just switch the teams in that sheet and it will then automatically swap those players in the individual team tabs. Is this possible?
Dude, why would you show us what shouldn't do while showing us what we are supposed to do? Can I make a suggestion? do a straight walk through of how to get from point a to point c with explanation of why you are doing each step, then go back and explain where people might make mistakes and other options to explain. Poorly made video!