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
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
AFTER LONG SEARCH, YOU ARE THE ONE
@captkantor
4 жыл бұрын
nicholes hoong Same here.
@pepper2705
2 жыл бұрын
Right?! best tutorial hands down!!
Best vlookup tutorial Ive seen so far. Thank you. Simple, clear, comprehensive.
I love your instruction style! Thank you for doing them at a slow pace so the learner can keep up!👏🏼👏🏼💕💕
Best tutorial on KZread. You made it look so simple. Thank you!
PERFECT TUTORING! Quick, understandable, practical!
This helped me out a lot. Short, to the point, and informable. Thank you :)
Great tutorial ! I have watched many but none of them explained you could capture data from other sheets! Awesome information! Thank you !
Had to rewatch your video 5 times to apply it for my purpose and it worked! Thank you!!
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!
You made it sound so simple! An excellent way to explain it. An excellent video use as well.
You are the only one that could teach this in a way I understand. Thank You.
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.
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.
i cried that finally i get to understand how to use this feature :`). Thank you Sir
Gosh you make it so simple and easy to understand . Thanks a million!
Your videos are simplified and easy to understand, God bless you!!
wow.. what an explanation with a great presentation.. I am glad that I have seen your great excel presentation.
Perfect video, thank you! Watched once and was able to get my work done first try. Simple and easy to understand.
Trying to advance to an intermediate level of Excel. Cody makes it possible when I can't. Thank you so much!
Very useful, clearly explained, thank you
thank you Cody, Simple and to the point.
Wow, this is such an excellent tutorial! Thanks so much for putting it together! 😉
Very Clear, I'll definitely watch all you videos soon :)
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.
Your videos are super helpful and easy to follow. Thank you.
Thank you Sir, you are the one we've been looking for years!
This is really good content, thanks for making these short introductions!
your content is awesome and teaches me better than class did!
Brilliant love this channel, vlookup explained in minutes - would love the source files - thank you
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
Thank you, that was precise and simple to understand.
I like iferror function, it helped me a lot. Thanks for video.
You Rock! Please keep these vids coming
Thank you. I learned something from you.
You are the man Cody I'm gonna get this job I'm interviewing for because of you!
Great video sensational presentation and you are a lifesaver. :) thank you very much expert!
Your videos are so great! Keep doing them please
Thank you and kindly do more tutorials 🙏🏾
Great explanation! Thanks Cody
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!
great video, simple to follow. Signed up for your course :)
Thank you so muchhhhhhh for this ,been looking for this bro
You do know how to communicate your knowledge! Thanks
Thanks!! I'm an expert now!
Super video, clean and precise
Well done Cody!
Detail and clear teaching.. thank you..
Thank you for making Excel so accessible! Great tutorial
Finally a good explanation, thanks!
Absolutely amazing!!
this was IT! this is the one, after 20 different videos, this is IT
May you channel grow by leaps and bounds.
Very cool dude! I love this video!!!!
Thank you sir , great explanation , your explanation helped me so much ,
May I please commend you on the incredibly pleasant and calm tone of your voice!
Very useful and simple explanation Thank you
Very helpful. Please add more videos. Thank you
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.
Best tutoring, easy to comprehend
Thank you!
This helped me. Thank you!
This is the most understandable tutorial 😎
Just perfect!
Do you have an example spreadsheet that we can download to practice? Loving your videos!
@kyleklassen3660
3 жыл бұрын
Check the description
ONCE AGAIN U R THE BEST
Thank u so much my struggle on it has endedddd
thank you so muchh! very helpful
would love to see a video about creating dashboards. thanks
The best vlookup tutorial video ! Thank you for up loading
This video may be 5 years ago but it's the only video that I found informative and straight to the point.
Wonderful job
Excellent tutorial
Omg thank you!!!
@akanshaparihar
4 жыл бұрын
Please do watch this, I hope you will like it:- kzread.info/dash/bejne/iqScmKqecru6ZtI.html
Thank you
Wow you explain awesome
Thank you.
Brilliant use of inserting data of one table of one sprea
I just learned a lot, but I wish your videos were longer.
again you are the best
He teach vlookup and iferror here. Thanks a lot. Helpful!
thank u !
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.
Life saver!
Ma Sha Allah. It is by the will of Allah Brilliant use and so accurately explained
MORE LESSONS PLS!!! 😁
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?
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?
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.
Excellent
You are the best
what is the short key for all fill function?
Finally!
Thank you!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
I watched this video. I just got hired as CEO. Thanks.
Finally i found one i understand
Thanks. Iferror was new for me
is that data file available
4:17 "Otterfill" But for reals, helpful video
Great 👍