Learn Vlookups in 7 Minutes (Microsoft Excel)

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
    @codymbaldwin5 жыл бұрын

    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
    @nicholeshoong36686 жыл бұрын

    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.85676 жыл бұрын

    Best vlookup tutorial Ive seen so far. Thank you. Simple, clear, comprehensive.

  • @healthstartshere
    @healthstartshere3 жыл бұрын

    I love your instruction style! Thank you for doing them at a slow pace so the learner can keep up!👏🏼👏🏼💕💕

  • @ronib7151
    @ronib71516 жыл бұрын

    Best tutorial on KZread. You made it look so simple. Thank you!

  • @moyoo189
    @moyoo1893 жыл бұрын

    PERFECT TUTORING! Quick, understandable, practical!

  • @WALbaby09
    @WALbaby095 жыл бұрын

    This helped me out a lot. Short, to the point, and informable. Thank you :)

  • @sisyouredopedritty4424
    @sisyouredopedritty44245 жыл бұрын

    Great tutorial ! I have watched many but none of them explained you could capture data from other sheets! Awesome information! Thank you !

  • @949surferdude
    @949surferdude4 жыл бұрын

    Had to rewatch your video 5 times to apply it for my purpose and it worked! Thank you!!

  • @eisenhoward1
    @eisenhoward12 жыл бұрын

    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!

  • @Inquisitive9
    @Inquisitive94 жыл бұрын

    You made it sound so simple! An excellent way to explain it. An excellent video use as well.

  • @zero112
    @zero1124 жыл бұрын

    You are the only one that could teach this in a way I understand. Thank You.

  • @karenjing9538
    @karenjing95382 жыл бұрын

    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.

  • @farhanakbar9896
    @farhanakbar98962 жыл бұрын

    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.

  • @lindanoor7485
    @lindanoor74854 жыл бұрын

    i cried that finally i get to understand how to use this feature :`). Thank you Sir

  • @sumaya3265
    @sumaya32654 жыл бұрын

    Gosh you make it so simple and easy to understand . Thanks a million!

  • @seanballroom9467
    @seanballroom94673 жыл бұрын

    Your videos are simplified and easy to understand, God bless you!!

  • @angelina_ruchi
    @angelina_ruchi4 жыл бұрын

    wow.. what an explanation with a great presentation.. I am glad that I have seen your great excel presentation.

  • @MarcusGuild
    @MarcusGuild2 жыл бұрын

    Perfect video, thank you! Watched once and was able to get my work done first try. Simple and easy to understand.

  • @spfox1014
    @spfox10142 жыл бұрын

    Trying to advance to an intermediate level of Excel. Cody makes it possible when I can't. Thank you so much!

  • @tawnyng
    @tawnyng6 жыл бұрын

    Very useful, clearly explained, thank you

  • @nappymantheking
    @nappymantheking4 жыл бұрын

    thank you Cody, Simple and to the point.

  • @christiegh8427
    @christiegh84274 жыл бұрын

    Wow, this is such an excellent tutorial! Thanks so much for putting it together! 😉

  • @joemawad891
    @joemawad8914 жыл бұрын

    Very Clear, I'll definitely watch all you videos soon :)

  • @BreannaLee21
    @BreannaLee215 жыл бұрын

    Dang! This was THE BEST tutorial on vlookups...you’re an amazing teacher, please return and make more lol!

  • @codymbaldwin

    @codymbaldwin

    5 жыл бұрын

    Thanks, Breanna! I am working on more as we speak.

  • @scusamancare
    @scusamancare4 жыл бұрын

    Your videos are super helpful and easy to follow. Thank you.

  • @ambroisejoly4097
    @ambroisejoly40973 жыл бұрын

    Thank you Sir, you are the one we've been looking for years!

  • @rjm842
    @rjm8422 жыл бұрын

    This is really good content, thanks for making these short introductions!

  • @danielaziz6538
    @danielaziz65384 жыл бұрын

    your content is awesome and teaches me better than class did!

  • @supersuperfastjellyf
    @supersuperfastjellyf3 жыл бұрын

    Brilliant love this channel, vlookup explained in minutes - would love the source files - thank you

  • @lboogie2679
    @lboogie26796 жыл бұрын

    Omg why did you stop making videos? This was the best excel video ever! Thank you

  • @codymbaldwin

    @codymbaldwin

    5 жыл бұрын

    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

  • @faymckenzie9319
    @faymckenzie93192 жыл бұрын

    Thank you, that was precise and simple to understand.

  • @borisgasparic3225
    @borisgasparic32256 жыл бұрын

    I like iferror function, it helped me a lot. Thanks for video.

  • @DajiaStar
    @DajiaStar4 жыл бұрын

    You Rock! Please keep these vids coming

  • @mercykoroyen30
    @mercykoroyen304 жыл бұрын

    Thank you. I learned something from you.

  • @cwerk24
    @cwerk243 жыл бұрын

    You are the man Cody I'm gonna get this job I'm interviewing for because of you!

  • @dominantcontinent
    @dominantcontinent4 жыл бұрын

    Great video sensational presentation and you are a lifesaver. :) thank you very much expert!

  • @bornfree6067
    @bornfree60673 жыл бұрын

    Your videos are so great! Keep doing them please

  • @crayfish3629
    @crayfish36293 жыл бұрын

    Thank you and kindly do more tutorials 🙏🏾

  • @srem1971
    @srem19713 жыл бұрын

    Great explanation! Thanks Cody

  • @bigboss1077
    @bigboss10773 жыл бұрын

    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!

  • @kristooley4112
    @kristooley41122 жыл бұрын

    great video, simple to follow. Signed up for your course :)

  • @bhrenwanders7860
    @bhrenwanders78603 жыл бұрын

    Thank you so muchhhhhhh for this ,been looking for this bro

  • @davidperea5668
    @davidperea56684 жыл бұрын

    You do know how to communicate your knowledge! Thanks

  • @WifeOfDJSteveHouston
    @WifeOfDJSteveHouston6 жыл бұрын

    Thanks!! I'm an expert now!

  • @MattJames37
    @MattJames374 жыл бұрын

    Super video, clean and precise

  • @alabalaalabala4208
    @alabalaalabala42086 жыл бұрын

    Well done Cody!

  • @jenniferliwang7094
    @jenniferliwang70943 жыл бұрын

    Detail and clear teaching.. thank you..

  • @spencer3501
    @spencer35019 ай бұрын

    Thank you for making Excel so accessible! Great tutorial

  • @ruthe.6975
    @ruthe.69753 жыл бұрын

    Finally a good explanation, thanks!

  • @jcanstar
    @jcanstar3 жыл бұрын

    Absolutely amazing!!

  • @jasoncave7551
    @jasoncave75513 жыл бұрын

    this was IT! this is the one, after 20 different videos, this is IT

  • @funguy29
    @funguy293 жыл бұрын

    May you channel grow by leaps and bounds.

  • @rc4652
    @rc46524 жыл бұрын

    Very cool dude! I love this video!!!!

  • @anudaviskalapurakkal5670
    @anudaviskalapurakkal56702 жыл бұрын

    Thank you sir , great explanation , your explanation helped me so much ,

  • @ParadoxicLunatic
    @ParadoxicLunatic2 жыл бұрын

    May I please commend you on the incredibly pleasant and calm tone of your voice!

  • @hushambabiker6715
    @hushambabiker67153 жыл бұрын

    Very useful and simple explanation Thank you

  • @maryamfarajnezhad6464
    @maryamfarajnezhad64644 жыл бұрын

    Very helpful. Please add more videos. Thank you

  • @kelliereviews5341
    @kelliereviews53416 жыл бұрын

    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.

  • @adebanty
    @adebanty2 жыл бұрын

    Best tutoring, easy to comprehend

  • @gavin3598
    @gavin35986 жыл бұрын

    Thank you!

  • @janenweike2614
    @janenweike26142 жыл бұрын

    This helped me. Thank you!

  • @RhizYT
    @RhizYT2 жыл бұрын

    This is the most understandable tutorial 😎

  • @jananivignesh8105
    @jananivignesh81054 жыл бұрын

    Just perfect!

  • @brookelong3630
    @brookelong36304 жыл бұрын

    Do you have an example spreadsheet that we can download to practice? Loving your videos!

  • @kyleklassen3660

    @kyleklassen3660

    3 жыл бұрын

    Check the description

  • @monarch.war2024
    @monarch.war20243 жыл бұрын

    ONCE AGAIN U R THE BEST

  • @vanziness4956
    @vanziness49563 жыл бұрын

    Thank u so much my struggle on it has endedddd

  • @nurulshafikah2970
    @nurulshafikah29703 жыл бұрын

    thank you so muchh! very helpful

  • @exwhyz33
    @exwhyz334 жыл бұрын

    would love to see a video about creating dashboards. thanks

  • @ny-mom2464
    @ny-mom24646 жыл бұрын

    The best vlookup tutorial video ! Thank you for up loading

  • @jericho1836
    @jericho18363 жыл бұрын

    This video may be 5 years ago but it's the only video that I found informative and straight to the point.

  • @attaulaleem3558
    @attaulaleem35584 жыл бұрын

    Wonderful job

  • @madhvipatel9423
    @madhvipatel94233 жыл бұрын

    Excellent tutorial

  • @Originataly
    @Originataly5 жыл бұрын

    Omg thank you!!!

  • @akanshaparihar

    @akanshaparihar

    4 жыл бұрын

    Please do watch this, I hope you will like it:- kzread.info/dash/bejne/iqScmKqecru6ZtI.html

  • @razvanbacauanu
    @razvanbacauanu4 жыл бұрын

    Thank you

  • @pyimoethan1
    @pyimoethan12 жыл бұрын

    Wow you explain awesome

  • @ahsanmohammed1
    @ahsanmohammed14 жыл бұрын

    Thank you.

  • @ahedsiddique7628
    @ahedsiddique76282 жыл бұрын

    Brilliant use of inserting data of one table of one sprea

  • @PhaMa1002
    @PhaMa10026 жыл бұрын

    I just learned a lot, but I wish your videos were longer.

  • @monarch.war2024
    @monarch.war20243 жыл бұрын

    again you are the best

  • @elizabethvenny98
    @elizabethvenny982 жыл бұрын

    He teach vlookup and iferror here. Thanks a lot. Helpful!

  • @ndelpurg
    @ndelpurg4 жыл бұрын

    thank u !

  • @jennylyu8215
    @jennylyu82154 жыл бұрын

    I know this might be off-topic, but your voice sounds exactly like the storyteller on my sleep meditation app

  • @pedroalejandroramirezorell7264

    @pedroalejandroramirezorell7264

    3 жыл бұрын

    His voice is very relaxing actually.

  • @wicharnangkhawut6301
    @wicharnangkhawut63012 жыл бұрын

    Life saver!

  • @ahedsiddique7628
    @ahedsiddique76282 жыл бұрын

    Ma Sha Allah. It is by the will of Allah Brilliant use and so accurately explained

  • @janeo14
    @janeo144 жыл бұрын

    MORE LESSONS PLS!!! 😁

  • @jacquelynhopkins9529
    @jacquelynhopkins95293 жыл бұрын

    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?

  • @alphacentauri2506
    @alphacentauri25063 жыл бұрын

    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?

  • @NVeva
    @NVeva6 жыл бұрын

    I know this video is old and maybe I'm missing something, but couldn't one filter the customer numbers on the phone number spreadsheet to match the customer numbers on the other, then copy and paste the data? Why is vlookup necessary for this?

  • @johnchapple9833

    @johnchapple9833

    6 жыл бұрын

    In this case, the customer numbers in this spreadsheet may not be in order, or in a different order than the sheet with the phone numbers, so copy and pasting would malign the phone numbers and customers.

  • @johnwylie9245
    @johnwylie92454 жыл бұрын

    Excellent

  • @dismaskimario389
    @dismaskimario3893 жыл бұрын

    You are the best

  • @vfvnxuan
    @vfvnxuan2 жыл бұрын

    what is the short key for all fill function?

  • @isoboyehorsfall8270
    @isoboyehorsfall82704 жыл бұрын

    Finally!

  • @MariaDiaz-qz9kg
    @MariaDiaz-qz9kg4 жыл бұрын

    Thank you!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

  • @hellotheremyolfriend
    @hellotheremyolfriend2 жыл бұрын

    I watched this video. I just got hired as CEO. Thanks.

  • @jaydahunter1369
    @jaydahunter13693 жыл бұрын

    Finally i found one i understand

  • @hassanalianees5530
    @hassanalianees55304 жыл бұрын

    Thanks. Iferror was new for me

  • @shahidrana8027
    @shahidrana80274 жыл бұрын

    is that data file available

  • @wyattpeterson6399
    @wyattpeterson63994 жыл бұрын

    4:17 "Otterfill" But for reals, helpful video

  • @allisonjoyalali2504
    @allisonjoyalali25042 жыл бұрын

    Great 👍