How to use VLOOKUP in Excel - Complete Kevin Stratvert
video description
Date: 2022-03-15
Related videos
Comments and reviews: 10
Chris
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?
reply
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?
reply
Ryan
Hey man. great job on all of this content! A good job slowing down your speaking. I think your videos could benefit a bit more if you actually paused for a few seconds between steps so that the viewer has enough time to mentally process what you are showcasing. I find myself having to pause and go back to watch certain sections in order to understand what you're doing. I'm not hating at all, and I'm VERY thankful for your hard work and videos. Just some constructive criticism. Keep up the good work!
reply
Hey man. great job on all of this content! A good job slowing down your speaking. I think your videos could benefit a bit more if you actually paused for a few seconds between steps so that the viewer has enough time to mentally process what you are showcasing. I find myself having to pause and go back to watch certain sections in order to understand what you're doing. I'm not hating at all, and I'm VERY thankful for your hard work and videos. Just some constructive criticism. Keep up the good work!
reply
Michael
Kevin, your tutorials are outstanding. One question in the vlookup tutorial, right around the section where you are pulling data from a completely different sheet, you click on a cell which then presents a [-[Cookies Ordered]] but nowhere do I see how you instructed for that to work. Did I miss something? When I click on it, it's just the cell ID that gets inserted.
reply
Kevin, your tutorials are outstanding. One question in the vlookup tutorial, right around the section where you are pulling data from a completely different sheet, you click on a cell which then presents a [-[Cookies Ordered]] but nowhere do I see how you instructed for that to work. Did I miss something? When I click on it, it's just the cell ID that gets inserted.
reply
David
-Hey Kev- the great thing about what I saw on this tute is you gave a brief disciption of yourself with no glowing resume like every other so-called tutor on youtube, Those that teach
guitar, Piano,woodworking car repair what eve,r you let your knowledge and delivery skills tell your back story top stuff
reply
-Hey Kev- the great thing about what I saw on this tute is you gave a brief disciption of yourself with no glowing resume like every other so-called tutor on youtube, Those that teach
guitar, Piano,woodworking car repair what eve,r you let your knowledge and delivery skills tell your back story top stuff
reply
ademigunle
Hi Kevin, thank you for sharing your knowledge with the world free of charge. Kevin, is it true that if a have between 15 to 20 column in an excel worksheet, VLOOKUP can only be reference on the number 1 column in my left hand side? if no can I reference column 5or 6 since I have 15 -20 columns ?
reply
Hi Kevin, thank you for sharing your knowledge with the world free of charge. Kevin, is it true that if a have between 15 to 20 column in an excel worksheet, VLOOKUP can only be reference on the number 1 column in my left hand side? if no can I reference column 5or 6 since I have 15 -20 columns ?
reply
Gimbalair
Where am i going wrong. I have a spreadsheet, in one column I type a number and based on a lookup table I want a 10 digit number to be populated in a different cell. Save me typing out the long number everytime. Not sure if i need the IF THEN function or this function
reply
Where am i going wrong. I have a spreadsheet, in one column I type a number and based on a lookup table I want a 10 digit number to be populated in a different cell. Save me typing out the long number everytime. Not sure if i need the IF THEN function or this function
reply
DG
IDEA!! I have an two different items in one column and a date they occured in another column -I am trying to figure out how to determine when both items happened on the same date and a SUM of that occurence together
reply
IDEA!! I have an two different items in one column and a date they occured in another column -I am trying to figure out how to determine when both items happened on the same date and a SUM of that occurence together
reply
R.D.
Fantastic video. You really should be a teacher/professor. You take a subject that can be daunting and break it down into very consumable steps. Thanks for your efforts.
reply
Fantastic video. You really should be a teacher/professor. You take a subject that can be daunting and break it down into very consumable steps. Thanks for your efforts.
reply
jason
wow i really appreciate this i have a test on this soon and i didnt really understand but thanks to this i do thanks a lot
also 200th comment :)
reply
wow i really appreciate this i have a test on this soon and i didnt really understand but thanks to this i do thanks a lot
also 200th comment :)
reply
Amy
Ok you lost me at HLookup and pressing F4 to get rid of the N/A's......what does F4 do? Why did we get N/A's on those responses??
---
reply
Ok you lost me at HLookup and pressing F4 to get rid of the N/A's......what does F4 do? Why did we get N/A's on those responses??
---
reply
Add a review, comment
Other channel videos
11:15
5:53
