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
6 жыл бұрын
AFTER LONG SEARCH, YOU ARE THE ONE
@captkantor
5 жыл бұрын
nicholes hoong Same here.
@pepper2705
2 жыл бұрын
Right?! best tutorial hands down!!
@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!
@farhanakbar9896
3 жыл бұрын
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.
@healthstartshere
3 жыл бұрын
I love your instruction style! Thank you for doing them at a slow pace so the learner can keep up!👏🏼👏🏼💕💕
@zero112
4 жыл бұрын
You are the only one that could teach this in a way I understand. Thank You.
@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.
@ronib7151
6 жыл бұрын
Best tutorial on KZitem. You made it look so simple. Thank you!
@ahedsiddique7628
2 жыл бұрын
Brilliant use of inserting data of one table of one sprea
@ParadoxicLunatic
2 жыл бұрын
May I please commend you on the incredibly pleasant and calm tone of your voice!
@MarcusGuild
2 жыл бұрын
Perfect video, thank you! Watched once and was able to get my work done first try. Simple and easy to understand.
@cwerk24
3 жыл бұрын
You are the man Cody I'm gonna get this job I'm interviewing for because of you!
@jasoncave7551
3 жыл бұрын
this was IT! this is the one, after 20 different videos, this is IT
@jericho1836
3 жыл бұрын
This video may be 5 years ago but it's the only video that I found informative and straight to the point.
@adebanty
2 жыл бұрын
Best tutoring, easy to comprehend
@funguy29
3 жыл бұрын
May you channel grow by leaps and bounds.
@sumaya3265
4 жыл бұрын
Gosh you make it so simple and easy to understand . Thanks a million!
@rjm842
2 жыл бұрын
This is really good content, thanks for making these short introductions!
@elizabethvenny98
3 жыл бұрын
He teach vlookup and iferror here. Thanks a lot. Helpful!
@Inquisitive9
4 жыл бұрын
You made it sound so simple! An excellent way to explain it. An excellent video use as well.
@danielaziz6538
4 жыл бұрын
your content is awesome and teaches me better than class did!
@ahedsiddique7628
2 жыл бұрын
Ma Sha Allah. It is by the will of Allah Brilliant use and so accurately explained
@RhizYT
2 жыл бұрын
This is the most understandable tutorial 😎
@supersuperfastjellyf
3 жыл бұрын
Brilliant love this channel, vlookup explained in minutes - would love the source files - thank you
@faymckenzie9319
2 жыл бұрын
Thank you, that was precise and simple to understand.
@crayfish3629
4 жыл бұрын
Thank you and kindly do more tutorials 🙏🏾
@tawnyng
6 жыл бұрын
Very useful, clearly explained, thank you
@joemawad891
4 жыл бұрын
Very Clear, I'll definitely watch all you videos soon :)
@brookelong3630
4 жыл бұрын
Do you have an example spreadsheet that we can download to practice? Loving your videos!
@kyleklassen3660
3 жыл бұрын
Check the description
@angelina_ruchi
4 жыл бұрын
wow.. what an explanation with a great presentation.. I am glad that I have seen your great excel presentation.
@ruthe.6975
3 жыл бұрын
Finally a good explanation, thanks!
@hellotheremyolfriend
2 жыл бұрын
I watched this video. I just got hired as CEO. Thanks.
@nappymantheking
4 жыл бұрын
thank you Cody, Simple and to the point.
@davidperea5668
4 жыл бұрын
You do know how to communicate your knowledge! Thanks
@christiegh8427
4 жыл бұрын
Wow, this is such an excellent tutorial! Thanks so much for putting it together! 😉
@jennylyu8215
4 жыл бұрын
I know this might be off-topic, but your voice sounds exactly like the storyteller on my sleep meditation app
@pedroalejandroramirezorell7264
3 жыл бұрын
His voice is very relaxing actually.
@bhrenwanders7860
3 жыл бұрын
Thank you so muchhhhhhh for this ,been looking for this bro
@borisgasparic3225
6 жыл бұрын
I like iferror function, it helped me a lot. Thanks for video.
would love to see a video about creating dashboards. thanks
@nurulshafikah2970
3 жыл бұрын
thank you so muchh! very helpful
@bigboss1077
4 жыл бұрын
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!
@alabalaalabala4208
6 жыл бұрын
Well done Cody!
@monarch.war2024
3 жыл бұрын
again you are the best
@vanziness4956
3 жыл бұрын
Thank u so much my struggle on it has endedddd
@DajiaStar
5 жыл бұрын
You Rock! Please keep these vids coming
@dominantcontinent
4 жыл бұрын
Great video sensational presentation and you are a lifesaver. :) thank you very much expert!
@rc4652
4 жыл бұрын
Very cool dude! I love this video!!!!
@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?
@jaydahunter1369
3 жыл бұрын
Finally i found one i understand
@NVeva
6 жыл бұрын
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
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.
@rudroroy1054
2 жыл бұрын
Will you be making a video on xlookup too?
@dismaskimario389
3 жыл бұрын
You are the best
@attaulaleem3558
4 жыл бұрын
Wonderful job
@ayushbhasin2906
3 жыл бұрын
Hello, When I am selecting Phone list in the Table Array; it is taking Customer and Full name as the selection. Hence, name is populating rather than Phone number. Please assist.
@hassanalianees5530
4 жыл бұрын
Thanks. Iferror was new for me
@vfvnxuan
2 жыл бұрын
what is the short key for all fill function?
@kongliu1467
3 жыл бұрын
You have a list with ordered customer number, so why don't you just copy and paste phone numbers directly from phone list?
@wicharnangkhawut6301
2 жыл бұрын
Life saver!
@wyattpeterson6399
4 жыл бұрын
4:17 "Otterfill" But for reals, helpful video
@Ladylee942
2 жыл бұрын
:( after i punch in Vlookup(highlight the cell, then when i punch comma, it give me a error.. Why?
@allisonjoyalali2504
3 жыл бұрын
Great 👍
@WifeOfDJSteveHouston
6 жыл бұрын
Thanks!! I'm an expert now!
@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.
@ahsanmohammed1
4 жыл бұрын
Thank you.
@kristooley4112
2 жыл бұрын
how do I contact you - I paid for your course and cannot access it. even with a PWD reset. Thanks
@MariaDiaz-qz9kg
4 жыл бұрын
Thank you!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
@GauravGupta-zq3hx
4 жыл бұрын
Thank you!
@jananivignesh8105
4 жыл бұрын
Just perfect!
@johnwylie9245
4 жыл бұрын
Excellent
@katd7716
2 жыл бұрын
why did you say column 2 instead of b?
@janeo14
4 жыл бұрын
MORE LESSONS PLS!!! 😁
@razvanbacauanu
4 жыл бұрын
Thank you
@jamaljenkins7098
Жыл бұрын
the goat
@Originataly
5 жыл бұрын
Omg thank you!!!
@akanshaparihar
4 жыл бұрын
Please do watch this, I hope you will like it:- kzitem.info/news/bejne/uaaenHybe4qFaaQ
@ndelpurg
4 жыл бұрын
thank u !
@isoboyehorsfall8270
4 жыл бұрын
Finally!
@thegodofbinary
Жыл бұрын
🍦🍦🍦💪💪💪 Good job
@shahidrana8027
4 жыл бұрын
is that data file available
@vfvnxuan
2 жыл бұрын
why 2?
@mixerman4541
6 жыл бұрын
Best tutorials, why are you making new videos?
@PhaMa1002
6 жыл бұрын
I just learned a lot, but I wish your videos were longer.
@evam.8567
6 жыл бұрын
Best vlookup tutorial Ive seen so far. Thank you. Simple, clear, comprehensive.
@pwill5601
4 жыл бұрын
Thank you!
@lindanoor7485
4 жыл бұрын
i cried that finally i get to understand how to use this feature :`). Thank you Sir
@lboogie2679
6 жыл бұрын
Omg why did you stop making videos? This was the best excel video ever! Thank you
@codymbaldwin
5 жыл бұрын
Aloha, Lala! I will get more posted soon.
@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
@Cloud_Vincent98
16 күн бұрын
I did same as u did but the dollar $ and decimal fraction didn't show up, the output was 8 instead of $8.00 can anyone help me cause am training in excel for my job
@WALbaby09
5 жыл бұрын
This helped me out a lot. Short, to the point, and informable. Thank you :)
@gavin3598
6 жыл бұрын
Thank you!
@user-tf7te5fs2n
3 жыл бұрын
I use convertcurrencytoenglish Iuse this function to convert numbers to words My question is how to add( US ) before (dollars)?????
@mjmash007
2 жыл бұрын
🥺🥺I haven't done excel in a while cos I've been working in a different industry for 4years. Now I got an interview test coming up tomorrow and trying to scrounge everything I can get in 24hours
@BreLJ
5 жыл бұрын
Dang! This was THE BEST tutorial on vlookups...you’re an amazing teacher, please return and make more lol!
@codymbaldwin
5 жыл бұрын
Thanks, Breanna! I am working on more as we speak.
@cassidydonshae398
3 жыл бұрын
NEO ladies and gentlemen, now I gotta find morpheus..😑
@vishnudadaindia3162
2 жыл бұрын
Good info but you didn't tell what that '2' meant by in formula?
@nainaiwhip4253
2 жыл бұрын
I'm getting error in my vlook results. It's writing #N/A
@sittieshahaniedelna8940
2 жыл бұрын
I FOLLOW THE FORMULA YET STILL N/A IS APPEARING. HELP!
Пікірлер: 139