Learn Vlookups in 7 Minutes (Microsoft Excel)

  Рет қаралды 486,414

Cody Baldwin

Cody Baldwin

8 жыл бұрын

Here is the sample file: www.codybaldwin.com/sample-fi.... Interested in learning more? You can use the following link to enroll in my course, "Become a Microsoft Excel Wizard in 1 Hour": www.codybaldwin.com/excel-course
Learn to use VLOOKUP formulas in 7 minutes... Vlookups allow you to search for related information in your spreadsheet or other spreadsheets. An example might be, you have a customer name and address, but you need to pull phone numbers from another spreadsheet.

Пікірлер: 138
@codymbaldwin
@codymbaldwin 4 жыл бұрын
What's up, Excel ninjas? I hope this video is helpful. I love me some vlookups! If you're interested in learning more, you can use the following link to enroll in my course, "Become a Microsoft Excel Wizard in 1 Hour": www.codybaldwin.com/excel-course
@nicholeshoong3668
@nicholeshoong3668 6 жыл бұрын
AFTER LONG SEARCH, YOU ARE THE ONE
@captkantor
@captkantor 4 жыл бұрын
nicholes hoong Same here.
@pepper2705
@pepper2705 2 жыл бұрын
Right?! best tutorial hands down!!
@evam.8567
@evam.8567 6 жыл бұрын
Best vlookup tutorial Ive seen so far. Thank you. Simple, clear, comprehensive.
@moyoo189
@moyoo189 3 жыл бұрын
PERFECT TUTORING! Quick, understandable, practical!
@healthstartshere
@healthstartshere 3 жыл бұрын
I love your instruction style! Thank you for doing them at a slow pace so the learner can keep up!👏🏼👏🏼💕💕
@ronib7151
@ronib7151 6 жыл бұрын
Best tutorial on KZbin. You made it look so simple. Thank you!
@sisyouredopedritty4424
@sisyouredopedritty4424 5 жыл бұрын
Great tutorial ! I have watched many but none of them explained you could capture data from other sheets! Awesome information! Thank you !
@eisenhoward1
@eisenhoward1 2 жыл бұрын
Wow, thanks for this! I've been trying to learn vlookup for months and this is one of the cleanest videos that explains it in baby steps! Thanks!
@WALbaby09
@WALbaby09 5 жыл бұрын
This helped me out a lot. Short, to the point, and informable. Thank you :)
@karenjing9538
@karenjing9538 2 жыл бұрын
Thank you!! So helpful. This is exactly what I needed b/c I was referencing across spreadsheets for work! So grateful for you. THank you for speaking so calmly too.
@949surferdude
@949surferdude 4 жыл бұрын
Had to rewatch your video 5 times to apply it for my purpose and it worked! Thank you!!
@farhanakbar9896
@farhanakbar9896 2 жыл бұрын
Excellent at teaching. Made this very simple to understand and straight to the point. He does not waffle on like other people in the videos I have viewed.
@zero112
@zero112 4 жыл бұрын
You are the only one that could teach this in a way I understand. Thank You.
@MarcusGuild
@MarcusGuild 2 жыл бұрын
Perfect video, thank you! Watched once and was able to get my work done first try. Simple and easy to understand.
@seanballroom9467
@seanballroom9467 3 жыл бұрын
Your videos are simplified and easy to understand, God bless you!!
@spfox1014
@spfox1014 2 жыл бұрын
Trying to advance to an intermediate level of Excel. Cody makes it possible when I can't. Thank you so much!
@Inquisitive9
@Inquisitive9 4 жыл бұрын
You made it sound so simple! An excellent way to explain it. An excellent video use as well.
@sumaya3265
@sumaya3265 4 жыл бұрын
Gosh you make it so simple and easy to understand . Thanks a million!
@ambroisejoly4097
@ambroisejoly4097 3 жыл бұрын
Thank you Sir, you are the one we've been looking for years!
@lindanoor7485
@lindanoor7485 4 жыл бұрын
i cried that finally i get to understand how to use this feature :`). Thank you Sir
@scusamancare
@scusamancare 4 жыл бұрын
Your videos are super helpful and easy to follow. Thank you.
@cwerk24
@cwerk24 3 жыл бұрын
You are the man Cody I'm gonna get this job I'm interviewing for because of you!
@nappymantheking
@nappymantheking 4 жыл бұрын
thank you Cody, Simple and to the point.
@spencer3501
@spencer3501 9 ай бұрын
Thank you for making Excel so accessible! Great tutorial
@tawnyng
@tawnyng 6 жыл бұрын
Very useful, clearly explained, thank you
@angelina_ruchi
@angelina_ruchi 4 жыл бұрын
wow.. what an explanation with a great presentation.. I am glad that I have seen your great excel presentation.
@joemawad891
@joemawad891 4 жыл бұрын
Very Clear, I'll definitely watch all you videos soon :)
@faymckenzie9319
@faymckenzie9319 2 жыл бұрын
Thank you, that was precise and simple to understand.
@rjm842
@rjm842 2 жыл бұрын
This is really good content, thanks for making these short introductions!
@christiegh8427
@christiegh8427 4 жыл бұрын
Wow, this is such an excellent tutorial! Thanks so much for putting it together! 😉
@srem1971
@srem1971 3 жыл бұрын
Great explanation! Thanks Cody
@danielaziz6538
@danielaziz6538 4 жыл бұрын
your content is awesome and teaches me better than class did!
@jenniferliwang7094
@jenniferliwang7094 3 жыл бұрын
Detail and clear teaching.. thank you..
@adebanty
@adebanty 2 жыл бұрын
Best tutoring, easy to comprehend
@kristooley4112
@kristooley4112 2 жыл бұрын
great video, simple to follow. Signed up for your course :)
@bornfree6067
@bornfree6067 3 жыл бұрын
Your videos are so great! Keep doing them please
@borisgasparic3225
@borisgasparic3225 6 жыл бұрын
I like iferror function, it helped me a lot. Thanks for video.
@jasoncave7551
@jasoncave7551 3 жыл бұрын
this was IT! this is the one, after 20 different videos, this is IT
@supersuperfastjellyf
@supersuperfastjellyf 3 жыл бұрын
Brilliant love this channel, vlookup explained in minutes - would love the source files - thank you
@MattJames37
@MattJames37 4 жыл бұрын
Super video, clean and precise
@jcanstar
@jcanstar 3 жыл бұрын
Absolutely amazing!!
@davidperea5668
@davidperea5668 4 жыл бұрын
You do know how to communicate your knowledge! Thanks
@anudaviskalapurakkal5670
@anudaviskalapurakkal5670 2 жыл бұрын
Thank you sir , great explanation , your explanation helped me so much ,
@ParadoxicLunatic
@ParadoxicLunatic 2 жыл бұрын
May I please commend you on the incredibly pleasant and calm tone of your voice!
@hushambabiker6715
@hushambabiker6715 3 жыл бұрын
Very useful and simple explanation Thank you
@crayfish3629
@crayfish3629 3 жыл бұрын
Thank you and kindly do more tutorials 🙏🏾
@mercykoroyen30
@mercykoroyen30 4 жыл бұрын
Thank you. I learned something from you.
@bhrenwanders7860
@bhrenwanders7860 3 жыл бұрын
Thank you so muchhhhhhh for this ,been looking for this bro
@madhvipatel9423
@madhvipatel9423 3 жыл бұрын
Excellent tutorial
@alabalaalabala4208
@alabalaalabala4208 6 жыл бұрын
Well done Cody!
@ruthe.6975
@ruthe.6975 3 жыл бұрын
Finally a good explanation, thanks!
@janenweike2614
@janenweike2614 2 жыл бұрын
This helped me. Thank you!
@dominantcontinent
@dominantcontinent 4 жыл бұрын
Great video sensational presentation and you are a lifesaver. :) thank you very much expert!
@BreannaLee21
@BreannaLee21 5 жыл бұрын
Dang! This was THE BEST tutorial on vlookups...you’re an amazing teacher, please return and make more lol!
@codymbaldwin
@codymbaldwin 4 жыл бұрын
Thanks, Breanna! I am working on more as we speak.
@maryamfarajnezhad6464
@maryamfarajnezhad6464 4 жыл бұрын
Very helpful. Please add more videos. Thank you
@DajiaStar
@DajiaStar 4 жыл бұрын
You Rock! Please keep these vids coming
@ahedsiddique7628
@ahedsiddique7628 2 жыл бұрын
Brilliant use of inserting data of one table of one sprea
@elizabethvenny98
@elizabethvenny98 2 жыл бұрын
He teach vlookup and iferror here. Thanks a lot. Helpful!
@nurulshafikah2970
@nurulshafikah2970 3 жыл бұрын
thank you so muchh! very helpful
@bigboss1077
@bigboss1077 3 жыл бұрын
Awesome video's Cody! short and to the point. Question- In the second example, did you have to copy and paste as values before doing the Total_Cost calulations by multiplying the Quantity and Unit_Price fields? thanks!
@monarch.war2024
@monarch.war2024 3 жыл бұрын
ONCE AGAIN U R THE BEST
@RhizYT
@RhizYT 2 жыл бұрын
This is the most understandable tutorial 😎
@rc4652
@rc4652 4 жыл бұрын
Very cool dude! I love this video!!!!
@pyimoethan1
@pyimoethan1 2 жыл бұрын
Wow you explain awesome
@monarch.war2024
@monarch.war2024 3 жыл бұрын
again you are the best
@funguy29
@funguy29 3 жыл бұрын
May you channel grow by leaps and bounds.
@lboogie2679
@lboogie2679 6 жыл бұрын
Omg why did you stop making videos? This was the best excel video ever! Thank you
@codymbaldwin
@codymbaldwin 4 жыл бұрын
Aloha, Lala! I will get more posted soon.
@apocalypsething8088
@apocalypsething8088 4 жыл бұрын
@@codymbaldwin your presentation is more better & step by step, slow paced understanding explanation in fact much better than Leila Gharani's video presentation keep it up tutor
@attaulaleem3558
@attaulaleem3558 4 жыл бұрын
Wonderful job
@WifeOfDJSteveHouston
@WifeOfDJSteveHouston 6 жыл бұрын
Thanks!! I'm an expert now!
@wicharnangkhawut6301
@wicharnangkhawut6301 2 жыл бұрын
Life saver!
@jananivignesh8105
@jananivignesh8105 4 жыл бұрын
Just perfect!
@ny-mom2464
@ny-mom2464 6 жыл бұрын
The best vlookup tutorial video ! Thank you for up loading
@dismaskimario389
@dismaskimario389 3 жыл бұрын
You are the best
@kelliereviews5341
@kelliereviews5341 6 жыл бұрын
is there a way to used vlookup to use an index match so that I am able to find a frequent customer just by there phone number, date of service and their full name? So I can use this feature in my user form.
@ahedsiddique7628
@ahedsiddique7628 2 жыл бұрын
Ma Sha Allah. It is by the will of Allah Brilliant use and so accurately explained
@gavin3598
@gavin3598 6 жыл бұрын
Thank you!
@exwhyz33
@exwhyz33 3 жыл бұрын
would love to see a video about creating dashboards. thanks
@vanziness4956
@vanziness4956 3 жыл бұрын
Thank u so much my struggle on it has endedddd
@ahsanmohammed1
@ahsanmohammed1 4 жыл бұрын
Thank you.
@razvanbacauanu
@razvanbacauanu 4 жыл бұрын
Thank you
@allisonjoyalali2504
@allisonjoyalali2504 2 жыл бұрын
Great 👍
@johnwylie9245
@johnwylie9245 4 жыл бұрын
Excellent
@brookelong3630
@brookelong3630 4 жыл бұрын
Do you have an example spreadsheet that we can download to practice? Loving your videos!
@kyleklassen3660
@kyleklassen3660 3 жыл бұрын
Check the description
@Originataly
@Originataly 5 жыл бұрын
Omg thank you!!!
@akanshaparihar
@akanshaparihar 4 жыл бұрын
Please do watch this, I hope you will like it:- kzbin.info/www/bejne/jqHLZ3ubd72HbNE
@ndelpurg
@ndelpurg 4 жыл бұрын
thank u !
@jericho1836
@jericho1836 3 жыл бұрын
This video may be 5 years ago but it's the only video that I found informative and straight to the point.
@MariaDiaz-qz9kg
@MariaDiaz-qz9kg 4 жыл бұрын
Thank you!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
@jaydahunter1369
@jaydahunter1369 3 жыл бұрын
Finally i found one i understand
@hassanalianees5530
@hassanalianees5530 3 жыл бұрын
Thanks. Iferror was new for me
@janeo14
@janeo14 4 жыл бұрын
MORE LESSONS PLS!!! 😁
@jamaljenkins7098
@jamaljenkins7098 Жыл бұрын
the goat
@vfvnxuan
@vfvnxuan 2 жыл бұрын
what is the short key for all fill function?
@rudroroy1054
@rudroroy1054 2 жыл бұрын
Will you be making a video on xlookup too?
@alphacentauri2506
@alphacentauri2506 3 жыл бұрын
Hi I have a question on the Vlookup-if I have a specific list of grocery items in one (workbook A ) and they are in column A ...and need to get the prices for those specific grocery items from another also in column A in (workbook B) and the prices are in column J and the second workbook has thousands of grocery items listed -how do I write the formula to extract only those specific items and their prices (from column J ) from the other sheet (workbook B) and enter only the specific items and their prices in Worksheet A?
@isoboyehorsfall8270
@isoboyehorsfall8270 4 жыл бұрын
Finally!
@hellotheremyolfriend
@hellotheremyolfriend 2 жыл бұрын
I watched this video. I just got hired as CEO. Thanks.
@jacquelynhopkins9529
@jacquelynhopkins9529 3 жыл бұрын
Great explanation but the iferror does not work on a mac if i leave a phone number blank it just returns a zero not an error. So the iferror does not recognize the 0 as an error. How do you fix?
@shajulislam95
@shajulislam95 2 жыл бұрын
Nice
@PhaMa1002
@PhaMa1002 6 жыл бұрын
I just learned a lot, but I wish your videos were longer.
@wyattpeterson6399
@wyattpeterson6399 4 жыл бұрын
4:17 "Otterfill" But for reals, helpful video
Learn Macros in 7 Minutes (Microsoft Excel)
7:40
Cody Baldwin
Рет қаралды 1,8 МЛН
ЧУТЬ НЕ УТОНУЛ #shorts
00:27
Паша Осадчий
Рет қаралды 8 МЛН
Cat Corn?! 🙀 #cat #cute #catlover
00:54
Stocat
Рет қаралды 16 МЛН
孩子多的烦恼?#火影忍者 #家庭 #佐助
00:31
火影忍者一家
Рет қаралды 52 МЛН
Excel Vlookup Tutorial - Everything You Need To Know
21:50
Excel Campus - Jon
Рет қаралды 2,5 МЛН
How to learn English on your own? |🎧 Podcast and Chill
18:51
LEP - Learn English Podcast
Рет қаралды 807
Build Interactive Dashboards in Microsoft Excel
26:14
Cody Baldwin
Рет қаралды 49 М.
AVOID MISTAKES MADE BY MARINA MOGILKO / STOP LEARNING THINGS WRONG / AVOID THESE MISTAKES
16:55
English for Everyone with Kevin and Liza
Рет қаралды 711
Advanced Excel - VLOOKUP Basics
11:58
Technology for Teachers and Students
Рет қаралды 2,1 МЛН
Top 10 Most Important Excel Formulas - Made Easy!
27:19
The Organic Chemistry Tutor
Рет қаралды 7 МЛН
Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)
14:48
Excel Campus - Jon
Рет қаралды 14 МЛН
ЧУТЬ НЕ УТОНУЛ #shorts
00:27
Паша Осадчий
Рет қаралды 8 МЛН