## Категории## Видео | ## VLOOKUP Function Beginner to Advanced 26 Examples: How To Use Excel VLOOKUP Function
## Похожие видео:## Комментарии:Автор khim seily ( назад)Why search function is put 7? And why minus 1? Автор Diana Michalevic ( назад)Amazing :) Thank you very very very much :) Автор Diosdado Miolata ( назад)superb!!!! Автор Harish Krishnamurthy ( назад)awesome! Автор tarine felix ( назад)@ExcelIsFun Really great tutorial! I have a question though.. can you put a vlook up for a whole category? example : there are 20 data, there are 4 categories (so 5 data have similar information), I want to look up one category, is there a function for that? Автор Kithsiri Advertising ( назад)Thank U Very much. I learn Lot Of things In This Video .Thank U again . TC Автор Tony Perez ( назад)This is a great way to learn and advance in excel, thank you for making it easy to understand. Автор Amanda Villaparedes ( назад)I have to bump up my excel skills for job applications since they test as part of the interview process. Your videos are amazing :) Автор Karla Duenas ( назад)You are the best! Автор jessie johnson ( назад)This was so helpful to me! My college classes never provide lechures and I'm preparing to take the MOS Excel Expert exams. i needed a source and this was truly perfect!! Автор Bruna Jermann (441 год назад)Amazing video! Thanks a lot!! Автор Tiffani Scott ( назад)Thank you so much this is wonderful! 37:00 is finally what I e been searching for. I'm keeping this video very good Автор Muhammad Naveed ( назад)REALLY EXCELLENT Автор md sahubar ( назад)excellent tutorial. keep it up Автор Callum Bannister ( назад)I sometimes find it really difficult to explain what I want Excel to do, so I could never really explain the issue.. This solves one of them perfectly and is pretty simple! Such a great resource, thank you for your time and effort! Much appreciated! Автор Cosmas Ezeuko ( назад)Good job ExcellsFun. Excellent With this kind of video free-of-charge, ignorance is a choice!!! Автор gayatri mahapatro ( назад)thank you sir Автор Mei Terumī Mizukage (1056 лет назад)I am really thank full for all the helpful tutorial.... You the best... ^_^ Автор only1barbi ( назад)I watched 5 other videos on VLookup before finding yours. Obviously, the first 5 didn't explain it very well or I wouldn't be here...THANK YOU FOR SIMPLIFYING THIS FOR ME AND PROBABLY SAVING MY JOB. TY TY TY Автор Devesh Somani ( назад)Sir! You are God Sent! Cannot thank you enough for what you do! Thank You! Thank You! Thank You! Автор Yannick Morgan ( назад)So you have to download the workbook sheet in order to do a vlookup through the workbook pages. does anyone know where I can go for that? This is regarding number 11 Автор Md Tofiqul Islam ( назад)আমার জীবনকে বদলে দিছে! (Excel Magic Trick) Автор Stephen Weiss ( назад)I tried the vlookup with choice of 2 columns (17 in the table of contents) in a very large worksheet. The formula only worked for the first two rows. The remaining 735 rows produced "n/a" error messages. I wound up creating a helper column (16 of the table of contents) but would have preferred the other formula to keep my worksheet clean. I used the $ sign in the arrays and then tried to remove them but nothing worked. F9 to see the formula did not work because the size exceeded the limits. Any ideas on what else I can try to make the choose function work? Автор MrFriedgreentomatos ( назад)I've just got one, No two comments, the first Thanks and the second ; "Boom" - cheers, an excellent video Автор harald808 (2009 лет назад)you went to fast on this tutorial Автор harald808 ( назад)i dint get it its seems hard or may be you dont know how to explain to the begginer Автор Justin Peters ( назад)It's incredible to see someone who is so savvy with excel! Practice makes perfect! Good stuff man! Keep them coming. If you have any room left from your THOUSANDS of useful and beneficial videos! Автор justin wang ( назад)it is very useful for me ,thank you Автор Mahfuzul Haque ( назад)good Автор jaena paula balbedina ( назад)Hello sir! Your Excel-lency, Mr. Mike Girvin! I'm a big fan of your work! You have a knack of making complicated stuff look easy peasy... It's me again. I don't know if you're viewing the comments since I understand this is waaay back and I did not receive a reply on my previous question. I just need to ask though with regards to PARTIAL TEXT LOOKUP, how do you make excel search/look up a name from a database by only the first three letter of the last name from a random list? In other words, how do I make Excel find the first 3 letters of any name from the list if I don't exactly know what to put in " " when I use SEARCH? Автор Osvaldo Aponte (204 года назад)This is awesome! Thank you! Автор jaena paula balbedina (1744 года назад)This is great! Thank you for sharing your extensive knowledge on Excel! You have opened my mind to a lot of possibilities and new ideas on what we could do with this powerful tool! I have a question though. I'M DOING A SORT OF TIME AND MOTION STUDY WHERE I NEED TO MEASURE THE NUMBER OF MINUTES IT TAKES TO DO A SERIES OF TASKS AGAINST THE NUMBER OF MINUTES IT TOOK TO WAIT IN BETWEEN THE TASKS (WAITING TIME VS. PROCESSING TIME), AND I'M USING THE FORMULA: Example: =MINUTE(B2-B1). THE FORMULA IS SUPPOSED TO SUBTRACT THE EARLIER TIME FROM THE LATER TIME. HOWEVER, MOST OF THE TIME IT'S NOT ACCURATE IF THE DIFFERENCE IS TOO BIG (MORE THAN 60 MINS). ALSO, IF IT'S HOURS APART IT DOESN'T COUNT THE HOURS BETWEEN POINT A AND POINT B. IT SEEMS EXCEL IS LIMITED WHEN COMPUTING MINUTES IF IT'S MORE THAN AN HOUR. DO U HAVE ANY WORKAROUNDS? Автор Maciej Berlinski ( назад)Thank you @ExcelIsFun for this one. On the basis of this I created a mobile number generator for 4 different source number types and 3 different outcome number types. All in one cell! Keep doing this great knowledge sharing as this is amazing! Автор Jaya Francis ( назад)Hi Your videos are really informative and clear and I've benefitted very much from it. I'm really a million $ thankful to you for what you upload in your channel. I've something to ask you. I've a situation where in a table; same look up value ( Eg: Carlota, Carlota Carlota) repeated three times and corresponding value in next column is different for each Carlota. For an argument This table has 2 columns only. I look up Carlota but obviously Look up function always gives "N/A" in cells. Would you please suggest if there's any function that can tell me if there's a function that can help me to find all the different values that a Carlota stands for in a table or a trick to tackle this situation. Can you also suggest if there's a function that will tell me how many times a Carlota is repeated in a table because I fed up using with Ctrl+F. Автор Marlene Pisani ( назад)I have done this and it does work but i have a table with over 20,000 items and some items might contain additional information that i dont always know, how can i create a formula that finds the first part of the item #, , most of my items are 8 digits long but then also have a space then other numbers,, example (900134142 120/60) ,or (900134142 24-60), is there a way or a special formula that will find these first numbers without having to know the last ones.? Автор Fernando García ( назад)Thanks :) ! Автор Ben Rawner ( назад)This video was excellent. Focused easy to understand and enlightening. You rock at teaching!!! Автор A KP ( назад)Excellent Tutorial! Loved it and learnt a lot of key uses. Thanks so much! Автор Bernhard Mallette ( назад)Great - very useful. Never done VLook ups before this was a great help Автор Dean House ( назад)Can i make a vlookup that will look for certain words in a sentence then return a value? So out of a the Principal payment for load id 374858375, can i search for "principal payment" and get it to return a value? Автор Aparna Shetty ( назад)Good quality teaching!!..now a days nothing is free. Appreciate your job here! Автор RealSacredCow (1257 лет назад)I have enjoyed these videos a lot over the years, and still learn something new with each video I watch. I have a question about something I have been working on recently. I am in a league that uses different point awarding scales based on where the person is in the brackets when facing an opponent. Example 1: Player A has 15 points Player B has 10 points When these players face each other, if Player B were to defeat Player A, they would be awarded 3 points. Though, if Player A were to defeat Player B, they would be awarded 2 points. Also, if by chance both Player A and Player B were to draw in their match, Player B would receive 1.5 points, and Player A would receive 1 point. Example 2: Player A has 9 points Player B has 9 points If either of these players were to win, they would receive 3 points. If they were to draw, they would each receive 1 point. Is there a way that this could be automated within Excel, using VLOOKUP, or another function(s) combination? Автор Adam Wallett ( назад)Thanks so much for putting tthis together :) Автор lpfanbase ( назад)For two way lookup (1:00:00) .. why is the match column array from A7 to F7? Shouldn't it just include B7:f7 ? Автор Jerome Cabaluna ( назад)How do you lookup if the lookup value is on the right side column and your value array is on the left side? Автор Bismark Adum-Kwapong ( назад)Great teaching and learning videos. Thanks for sharing. Автор Mohit Saini ( назад)cant get the Work Book sir.. please help Автор grammar police ( назад)Orientating is not a word; the correct term is orienting. Автор Prasad Jampana ( назад)Great video...Thank you! Автор UP VYPAAR.IN ( назад)grt lokk Автор Emilie Priyadarshini ( назад)Hi +ExcelIsFun I really like your YouTube videos series. I am so curious to know about how much time and efforts did you put to make this kind of videos? Do you do this full time or do you do it when you have time on weekends? How much time do you give daily to make these videos? do you make it at home or you went to some professional studio? What kind of tools do you use to record these videos? Do you record and edit this video by ownself or do you hire some company to do that? What kind of benefits do you get because of these videos? How much money did you spend on this and how much money do you generate from YouTube monetisation? Is it good idea to make video and give it for FREE rather then writing a book? share your tips to make this kind of exclusive youtube channel. Who should make these kind of videos.? Автор Rafael Pires ( назад)Thank you for sharing your knowledge. I got a new job and one of my duties is evaluate and develop reportings and I was pretty worried about that...I´m glad I found your channel, it's helping me a lot. Автор Abdi Shibis ( назад)How come I can not use Ctrl+F3 another sheet to get NamedRange DLBoomerangs? You didn't mention if this trick of Vlookup with Named Range Trick can only be applied with the same Working Sheet or different sheets. Also don't i need to use F4 when i select the Range or it don't matter? By the way I am obsessed your website http://www.mrexcel.com/learnexcel/tag/excelisfun/ and Youtube (Excellsfun) and I am your Twitter @ExcelIsFun Follower. Автор So Happy To Sew ( назад)Ok, I have a question for you, and I'm not even sure how to write it out. :) I'm trying to affinitize a list of ~1,500 project ideas (text field), using a list of approximately 50 "buckets", which are also text. For instance, one project idea might be something like, "Use 3D printing for low volume parts", another idea might be something about an end cap, or a latch, or whatever. My list of bucket items have things like: 3D printing, end cap, latch, etc. How do I get the formula to return the appropriate bucket item (3D printing, end cap, etc.) relative to what's in the text for a project idea? Thanks! Автор Nivek ( назад)Thanks Man you will help me to get a Job Автор Rade Blanusa ( назад)WOW! Great stuff bud. Big fan here <---- Автор JOE SKINZ ( назад)This helped big time. Thanks for putting this togther Автор coachgeo ( назад)ok Vlookup might be good for my needs..... but.... there is a stick in the mud that might make it not usable for me. Let's say I have a table of data. Strung out on one row across the columns with about 30 bits of info; each in it's own cell/column on that row. About 300 rows total in the table. First cell of each row identifies say Boomarang color's that can vary say blue, red, yellow etc. With V lookup I can pull all the data of each of the blue boomrangs (of various types, brands etc.) to a new location where I can deal with Just the blue one's out of the 300+ records of all the boomarangs. Now when dealing with these Blue ones I will be changing data in it's associated cell/columns; example cost in one column and diameter in another, type of plastic used AND dates each of these records were changed. Here is the stickler... on the fly or end of day? how do I get this new updated info for all the blue ones back to where the original/primary data table is kept? Is there a "V-Send it back to it's home table and location" command :) ? PS- reason Vlook up is potentially better than just "sorting" the original table is I find the date's I get recorded in a cell via circular reference formulas that record dates (Today command) when data changes, *somehow these dates get changed to "the date the sort was done" instead of keeping the date that was recorded on the original date the data was changed. I need these dates for legal reasons. I'm not doing boomarangs obviously. This is student progress records * these date's getting changed was happening in OOCalc. Just recently got Excel 2007 but concepts across the two are strikingly similar and was told by others Excel would react the same way. Hope this makes since. Автор ExcelIsFun ( назад)Harmanpreet Singh , try: Highline Excel 2013 Class Video 19: Text Functions RIGHT, LEFT, MID, SEARCH for Partial Text VLOOKUP https://www.youtube.com/watch?v=vbu0PX8_hm0 Автор ExcelIsFun ( назад)Harmanpreet Singh , try: https://www.youtube.com/watch?v=vbu0PX8_hm0 Автор Harmanpreet Singh ( назад)This was very helpful for me. But I have Question, In case of Partial text- If Mid ID and Right ID is not consistent then what would be the formula for above situation? Автор Mutlu Gundiler (1919 лет назад)One can't learn any more within one hour. Thanks much. Автор Ahmed Ryan ( назад)Man,that is absolutely amazing ..thanks man Автор MILWAUKEE “JETSTREAM” MOTOR ( назад)why does there have to be data in a15 for the formula to work why cant I use a5 Автор MILWAUKEE “JETSTREAM” MOTOR ( назад)if I enter a5 as the vlookup formula it doesn't work why do I have to use a15 and not a5 in the formula please clarify? I think I am missing a point Автор workpays ( назад)Thank you. Really. Автор Tracey Donoghue ( назад)What a great tool! I've shared this with my team - I hope it saves me a lot of future coaching. Thanks for putting this together! Автор Wong Liyong ( назад)awesome video Автор carrieyueng ( назад)Автор 92shehan ( назад)Hi. Is it no longer possible to download the work books? Автор Body Nation USA ( назад)What an awesome video! I wish I would have come across it a bit sooner because I've already flunked my midterm..... Автор Prashanth A ( назад)OMG. All these days i am struggling with Vlookup because data format is not unique everytime.This video explained me how to use lookup without adjusting existing data. I love this. Автор Garra Gao ( назад)Thank you, man!!!!! Автор Tyler Schaner ( назад)First off, great video! Extremely helpful. As for my question; regarding duplicate values in the "lookup_value" the vlookup will only register the first value it finds, is there a way to get all values? Example: my lookup_value are dates (3/6/2015) and my col_index_num are dollar amounts and I'm trying to add all sales on 3/6/2015. It currently is registering the first sale 3/6/2015 however the subsequent sales are not being added to the grand total. Having 2 look up values wouldn't work because there are duplicate sale totals (i.e. both lookup_value's are 3/6/2015 & both col_index_num's are $160) They need to be separated to denote separate transactions. Thank you in advance!! Автор Handoko Liam Rianto ( назад)Hi, I just realized all this time I've been using the wrong lookup function, I keep using LookUP() function for a vertical table everytime I have new values I have to update the table in alphabetical order. However with Vlookup I dont' have too. Any disadvantage of Vlookup I need to be aware of? Thanks. Автор Gareth Reagan ( назад)Regarding using CHOOSE to work with multiple tables, if there are many tables to choose from would it be more efficient to name the ranges of each table then use INDIRECT in the VLOOKUP second argument to build the name of the correct table and then return the array of data? e.g. Name data range in the 3 tables tblABC, tblEDR and tblEDS, then use VLOOKUP(B4,INDIRECT("tbl"&A4),2) in your example 17. Автор ssp1r1t ( назад)At the "Two Way Lookup" is it ok to use this formula =INDEX(B8:F12;MATCH(B3;A8:A12);MATCH(B4;B7:F7)) Instead of the VLOOKUP Автор delboytrotter77 ( назад)The video was epic and I fully enjoyed it esp. the 'Trim' function as well as the dynamic tables!! two thumbs up! Автор Cheryl Clarke ( назад)Thank you!!!!!! This is so clear and to the point...savior! Автор Tony Valadez ( назад)You helped me nail a job interview. Thank you!!!! Автор Jamie Bates ( назад)Great video. VERY, VERY helpful. Question (44.54 min) why did you use -1 in the SEARCH function? Автор Joyousj ( назад)OMG just stumbled on your video..THAAAAANK YOOOOU! THIS right here, just saved my butt! Whew. Going to make my job a lot easier! Be blessed! Автор helen gatlin ( назад)very good vlookup tutorial, and a long one. Spent some very valuable time on this. Thank you very much for sharing this wonderful video and workbook with us. Автор Michael Min ( назад)I was so lost with vlookup and other excel functions at work and you just taught me all of those in an hour! AMAZING! Thank you very much for sharing these valuable videos :) Автор Yay Joe ( назад)hey Mike, thanks for this. Can you show how to do the same trick with the RIGHT function? In the last case you have assumed that the last part of the string will always have only 3 characters. What if that too is varying? How can we extract it? as an example, suppose the data was: Bellen-234-BB25R Carlota-345-CC11120R Quad-765-QQQ20LJK Автор L'Ranj V ( назад)you are awesome! Thank you! Автор Sam Diboma ( назад)Please how can I merge 12 excel sheets containing data of 50 countries spread over 30 years using the VLOOKUP function (the data are contained in one excel file) Thanks Автор Vatthana Batonunh ( назад)Million thanks for useful trick ## Вставка видео: | ## Поиск Видео## Top Видео |