Тёмный
No video :(

Learn Vlookups in 7 Minutes (Microsoft Excel) 

Cody Baldwin
Подписаться 84 тыс.
Просмотров 487 тыс.
50% 1

Here is the sample file: www.codybaldwi.... Interested in learning more? You can use the following link to enroll in my course, "Become a Microsoft Excel Wizard in 1 Hour": www.codybaldwi...
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.

Опубликовано:

 

27 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 138   
@codymbaldwin
@codymbaldwin 5 лет назад
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 5 лет назад
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.
@ahedsiddique7628
@ahedsiddique7628 2 года назад
Brilliant use of inserting data of one table of one sprea
@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!
@spfox1014
@spfox1014 2 года назад
Trying to advance to an intermediate level of Excel. Cody makes it possible when I can't. Thank you so much!
@moyoo189
@moyoo189 3 года назад
PERFECT TUTORING! Quick, understandable, practical!
@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.
@jasoncave7551
@jasoncave7551 3 года назад
this was IT! this is the one, after 20 different videos, this is IT
@healthstartshere
@healthstartshere 3 года назад
I love your instruction style! Thank you for doing them at a slow pace so the learner can keep up!👏🏼👏🏼💕💕
@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.
@lindanoor7485
@lindanoor7485 4 года назад
i cried that finally i get to understand how to use this feature :`). Thank you Sir
@BreLJ
@BreLJ 5 лет назад
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.
@spencer3501
@spencer3501 10 месяцев назад
Thank you for making Excel so accessible! Great tutorial
@cwerk24
@cwerk24 3 года назад
You are the man Cody I'm gonna get this job I'm interviewing for because of you!
@lboogie2679
@lboogie2679 6 лет назад
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
@seanballroom9467
@seanballroom9467 3 года назад
Your videos are simplified and easy to understand, God bless you!!
@ParadoxicLunatic
@ParadoxicLunatic 2 года назад
May I please commend you on the incredibly pleasant and calm tone of your voice!
@MarcusGuild
@MarcusGuild 2 года назад
Perfect video, thank you! Watched once and was able to get my work done first try. Simple and easy to understand.
@ronib7151
@ronib7151 6 лет назад
Best tutorial on RU-vid. 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 !
@949surferdude
@949surferdude 4 года назад
Had to rewatch your video 5 times to apply it for my purpose and it worked! Thank you!!
@elizabethvenny98
@elizabethvenny98 3 года назад
He teach vlookup and iferror here. Thanks a lot. Helpful!
@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.
@hellotheremyolfriend
@hellotheremyolfriend 2 года назад
I watched this video. I just got hired as CEO. Thanks.
@adebanty
@adebanty 2 года назад
Best tutoring, easy to comprehend
@WALbaby09
@WALbaby09 5 лет назад
This helped me out a lot. Short, to the point, and informable. Thank you :)
@RhizYT
@RhizYT 2 года назад
This is the most understandable tutorial 😎
@funguy29
@funguy29 3 года назад
May you channel grow by leaps and bounds.
@ambroisejoly4097
@ambroisejoly4097 3 года назад
Thank you Sir, you are the one we've been looking for years!
@jenniferliwang7094
@jenniferliwang7094 3 года назад
Detail and clear teaching.. thank you..
@crayfish3629
@crayfish3629 3 года назад
Thank you and kindly do more tutorials 🙏🏾
@ahedsiddique7628
@ahedsiddique7628 2 года назад
Ma Sha Allah. It is by the will of Allah Brilliant use and so accurately explained
@rjm842
@rjm842 2 года назад
This is really good content, thanks for making these short introductions!
@supersuperfastjellyf
@supersuperfastjellyf 3 года назад
Brilliant love this channel, vlookup explained in minutes - would love the source files - thank you
@scusamancare
@scusamancare 4 года назад
Your videos are super helpful and easy to follow. Thank you.
@danielaziz6538
@danielaziz6538 4 года назад
your content is awesome and teaches me better than class did!
@faymckenzie9319
@faymckenzie9319 2 года назад
Thank you, that was precise and simple to understand.
@anudaviskalapurakkal5670
@anudaviskalapurakkal5670 2 года назад
Thank you sir , great explanation , your explanation helped me so much ,
@madhvipatel9423
@madhvipatel9423 3 года назад
Excellent tutorial
@hushambabiker6715
@hushambabiker6715 3 года назад
Very useful and simple explanation Thank you
@kristooley4112
@kristooley4112 2 года назад
great video, simple to follow. Signed up for your course :)
@sumaya3265
@sumaya3265 4 года назад
Gosh you make it so simple and easy to understand . Thanks a million!
@maryamfarajnezhad6464
@maryamfarajnezhad6464 4 года назад
Very helpful. Please add more videos. Thank you
@Inquisitive9
@Inquisitive9 4 года назад
You made it sound so simple! An excellent way to explain it. An excellent video use as well.
@ruthe.6975
@ruthe.6975 3 года назад
Finally a good explanation, thanks!
@bornfree6067
@bornfree6067 4 года назад
Your videos are so great! Keep doing them please
@srem1971
@srem1971 3 года назад
Great explanation! Thanks Cody
@davidperea5668
@davidperea5668 4 года назад
You do know how to communicate your knowledge! Thanks
@tawnyng
@tawnyng 6 лет назад
Very useful, clearly explained, thank you
@ahedsiddique7628
@ahedsiddique7628 2 года назад
Brilliant way of inserting one table date of one Excel spreadsheet into another spreadsheet .
@joemawad891
@joemawad891 4 года назад
Very Clear, I'll definitely watch all you videos soon :)
@janenweike2614
@janenweike2614 3 года назад
This helped me. 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.
@nappymantheking
@nappymantheking 4 года назад
thank you Cody, Simple and to the point.
@bhrenwanders7860
@bhrenwanders7860 3 года назад
Thank you so muchhhhhhh for this ,been looking for this bro
@pyimoethan1
@pyimoethan1 3 года назад
Wow you explain awesome
@borisgasparic3225
@borisgasparic3225 6 лет назад
I like iferror function, it helped me a lot. Thanks for video.
@MattJames37
@MattJames37 4 года назад
Super video, clean and precise
@monarch.war2024
@monarch.war2024 3 года назад
ONCE AGAIN U R THE BEST
@brookelong3630
@brookelong3630 4 года назад
Do you have an example spreadsheet that we can download to practice? Loving your videos!
@kyleklassen3660
@kyleklassen3660 3 года назад
Check the description
@vanziness4956
@vanziness4956 3 года назад
Thank u so much my struggle on it has endedddd
@mercykoroyen30
@mercykoroyen30 4 года назад
Thank you. I learned something from you.
@jennylyu8215
@jennylyu8215 4 года назад
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.
@jcanstar
@jcanstar 3 года назад
Absolutely amazing!!
@nurulshafikah2970
@nurulshafikah2970 3 года назад
thank you so muchh! very helpful
@christiegh8427
@christiegh8427 4 года назад
Wow, this is such an excellent tutorial! Thanks so much for putting it together! 😉
@exwhyz33
@exwhyz33 4 года назад
would love to see a video about creating dashboards. thanks
@monarch.war2024
@monarch.war2024 3 года назад
again you are the best
@alabalaalabala4208
@alabalaalabala4208 6 лет назад
Well done Cody!
@wicharnangkhawut6301
@wicharnangkhawut6301 2 года назад
Life saver!
@dismaskimario389
@dismaskimario389 3 года назад
You are the best
@dominantcontinent
@dominantcontinent 4 года назад
Great video sensational presentation and you are a lifesaver. :) thank you very much expert!
@attaulaleem3558
@attaulaleem3558 4 года назад
Wonderful job
@jaydahunter1369
@jaydahunter1369 3 года назад
Finally i found one i understand
@ny-mom2464
@ny-mom2464 6 лет назад
The best vlookup tutorial video ! Thank you for up loading
@DajiaStar
@DajiaStar 5 лет назад
You Rock! Please keep these vids coming
@hassanalianees5530
@hassanalianees5530 4 года назад
Thanks. Iferror was new for me
@rc4652
@rc4652 4 года назад
Very cool dude! I love this video!!!!
@PhaMa1002
@PhaMa1002 6 лет назад
I just learned a lot, but I wish your videos were longer.
@NVeva
@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
@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.
@mjmash007
@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
@ayushbhasin2906
@ayushbhasin2906 2 года назад
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.
@allisonjoyalali2504
@allisonjoyalali2504 3 года назад
Great 👍
@bigboss1077
@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!
@vfvnxuan
@vfvnxuan 2 года назад
what is the short key for all fill function?
@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?
@jacquelynhopkins9529
@jacquelynhopkins9529 4 года назад
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?
@vishnudadaindia3162
@vishnudadaindia3162 2 года назад
Good info but you didn't tell what that '2' meant by in formula?
@kongliu1467
@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?
@Ladylee942
@Ladylee942 2 года назад
:( after i punch in Vlookup(highlight the cell, then when i punch comma, it give me a error.. Why?
@user-tf7te5fs2n
@user-tf7te5fs2n 3 года назад
I use convertcurrencytoenglish Iuse this function to convert numbers to words My question is how to add( US ) before (dollars)?????
@wyattpeterson6399
@wyattpeterson6399 4 года назад
4:17 "Otterfill" But for reals, helpful video
@WifeOfDJSteveHouston
@WifeOfDJSteveHouston 6 лет назад
Thanks!! I'm an expert now!
@janeo14
@janeo14 4 года назад
MORE LESSONS PLS!!! 😁
@MariaDiaz-qz9kg
@MariaDiaz-qz9kg 4 года назад
Thank you!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
@jamaljenkins7098
@jamaljenkins7098 Год назад
the goat
@johnwylie9245
@johnwylie9245 4 года назад
Excellent
@jananivignesh8105
@jananivignesh8105 4 года назад
Just perfect!
Далее
Build Interactive Dashboards in Microsoft Excel
26:14
НЕ ИГРАЙ В ЭТУ ИГРУ! 😂 #Shorts
00:28
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
Stop using VLOOKUP in Excel. Switch to INDEX MATCH
11:05
Learn Macros in 7 Minutes (Microsoft Excel)
7:40
Просмотров 1,8 млн
Top 10 Most Important Excel Formulas - Made Easy!
27:19
How to Use VLOOKUP to Compare Two Lists
15:20
Просмотров 796 тыс.
Advanced Excel - VLOOKUP Basics
11:58
Просмотров 2,2 млн
Vlookup Function in Excel for Beginners
11:35
Просмотров 1,7 млн