VLOOKUP Function Beginner to Advanced 26 Examples: How To Use Excel VLOOKUP Function

  • Опубликовано: 26 мар 2012
  • Download Start File: people.highline.edu/mgirvin/RUclipExcelIsFun/VLOOKUP-SHARK-WEEK-DoawnloadableWorkbook01-Start.xlsx
    Download Finished File: people.highline.edu/mgirvin/RUclipExcelIsFun/VLOOKUP-SHARK-WEEK-DoawnloadableWorkbook01-FINISHED.xlsx
    Entire Page with All Files for All Videos: people.highline.edu/mgirvin/excelisfun.htm
    Then scroll down to this section: "VLOOKUP "Shark" Week Downloadable Workbooks"
    Look for the file named: VLOOKUP-SHARK-WEEK-DownloadableWorkbook01-Start.xlsx
    Excel VLOOKUP is one of the most important functions because everyone needs to look stuff up. Not only that, but if you want to get a job, you must know VLOOKUP.
    In this video learn everything you need to know about VLOOKUP in 1 video.
    Here are the topics (minute marks jump you to that part of the video):
    1. VLOOKUP = V = Vertical ( min)
    2. Why so common? Because everyone needs to look stuff up ( 00:43 min)
    3. VLOOKUP Delivers a value to a cell: Extract Match ( 2:37 min)
    4. VLOOKUP #N/A and IFERROR or IF ( 5:25 min)
    5. VLOOKUP and Data Validation ( 8:10 min)
    6. VLOOKUP with Named Range ( 10:34 min)
    7. VLOOKUP as Formula Element ( 17:24 min)
    8. HLOOKUP = H = Horizontal ( 18:25 min)
    9. VLOOKUP Delivers a value to a cell: Approximate Match ( 19:40 min)
    10. VLOOKUP with table on different sheet ( 24:00 min)
    11. VLOOKUP with table in different workbook ( 25:56 min)
    12. Show Full Record: Numbers above column header ( 27:15 min)
    13. Show Full Record horizontally: COLUMNS Function ( 30:20 min)
    14. Show Full Record vertically: ROWS Function ( 32:28 min)
    15. Show Full Record: MATCH Functions ( 33:40 min)
    16. Two Lookup Values: Add join column as first column in table ( 35:40 min)
    17. Two Lookup Values: Join columns in formula and use CHOOSE function ( 38:50 min)
    18. Partial Text Lookup: LEFT and SEARCH Functions ( 43:22 min)
    19. Partial Text Lookup: MID Function ( 45:37 min)
    20. Partial Text Lookup: RIGHT Function ( 48:08 min)
    21. TRIM and VLOOKUP: Space in lookup value ( 48:57 min)
    22. TRIM and VLOOKUP: Space in 1st column of table ( 51:03 min)
    23. VLOOKUP with 3 lookup tables: CHOOSE Function ( 53:20 min)
    24. VLOOKUP: Two Way Lookup with VLOOKUP and MATCH ( 58:36 min)
    25. VLOOKUP: Variable Tax Rate, 3 VLOOKUPS in one formula ( 1:00:18 min)
    26. VLOOKUP and Table feature for Dynamic ranges ( 1:05:17 min)
    VLOOKUP Shark WEEK
    How To Use Excel VLOOKUP Function
    Learn Excel VLOOKUP Function
    VLOOKUP made easy
    Excel VLOOKUP
    Excel VLOOKUP Function

Комментарии • 1 633

  • Brett B
    Brett B День назад

    A little too fast in explaining.

  • shubham aggarwal
    shubham aggarwal 2 дня назад

    Absolute genius...

  • Vincent Lau
    Vincent Lau 10 дней назад

    The author said "this is going to be an epic vlookup tutorial at the start". It is, I concur! Thank you so much. This is a masterpiece of vlookup tutorial.

    • ExcelIsFun
      ExcelIsFun  9 дней назад

      Glad you like the video!!! Thanks for the support with your comment, Thumbs Up and Sub : )

  • kabir basu
    kabir basu 11 дней назад

    Very helpful video. Thanks.

  • Papa Pidos
    Papa Pidos 19 дней назад

    EXCELLENT! HATS OFF TO U SIR. THANKS A LOT!! GOD BLESS

  • Ellen-Jane Brooks
    Ellen-Jane Brooks 27 дней назад

    Thank you for the amazing video. I have dyslexia and I've always struggled with vlookup, your video is so easy to follow. Just wondering if you could help me further please.
    I need to make a report that draws data from a shared drive. Once all data found, I need to make a graph from this data. (example) bottom half project forecast, Middle actuals, top why are we over or under.
    Can you help me with this or direct me in the right direction please.

  • shashikiran R
    shashikiran R 28 дней назад

    I'm Using WS spreadsheet instead of excel ,in the dynamic part i am not getting the result with the formula. please guide me ?

  • nikitha niki
    nikitha niki 29 дней назад

    Sir yourVlookup class is excellent, and your teaching style made me sit for a long time...my learning went on very interesting. Thank you so much for your efforts at free of cost for us...I am lucky I attended your class

    • ExcelIsFun
      ExcelIsFun  29 дней назад

      You are welcome! You can pay back the favor with a Thumbs Up and a Sub : ) Thanks for your support and comment!!

  • Doaa Samir
    Doaa Samir Месяц назад

    Great video & very supportive ,,,, Thanks!

  • Behlul antri
    Behlul antri Месяц назад

    Hi, I have a problem to solve can u help? its in excel woorksheet

  • Quality Repair
    Quality Repair 2 месяца назад

    GREAT JOB. VLOOKUP SIMPLIFIED, IN A CLEAR AND CONCISE VIDEO. GREAT JOB.

  • jacky chawla
    jacky chawla 2 месяца назад

    Introduced vba in excel sir ......mike

  • Steve Cancel
    Steve Cancel 2 месяца назад

    Hi Mike, I can't use the F4 keyboard shortcut with a Mac.... other than manually typing in the $ signs, is there an alternative if Im using excel for Mac?

  • nora laboy
    nora laboy 2 месяца назад

    I have watched 2 hours worth of people try to teach this formula and have not been able to understand. Your easy explanation on how our thought process is exactly the excel thinking has allowed me to finally learn how to use it. Thank you!

    • ExcelIsFun
      ExcelIsFun  2 месяца назад

      You are welcome! I am glad you finally know VLOOKUP! Thanks for the support with your comment, Thumbs Up and Sub : )

  • Vishal Kumar
    Vishal Kumar 3 месяца назад

    Thank you for sharing Sir

    • ExcelIsFun
      ExcelIsFun  2 месяца назад

      You are welcome! Thanks for the support with your comment, Thumbs Up and Sub : )

  • Anita Burke
    Anita Burke 3 месяца назад

    4:25 I've always noticed that people get the most confused by forgetting that the lookup value MUST be in column 1. I have also messed myself up time and again, by forgetting to fill down when I have a formula column, which is almost always. I either get a #N/A and cant figure out why, or worse yet, you won't notice if your average etc is off because you didn't fill down your formula

  • alexander akinkugbe
    alexander akinkugbe 3 месяца назад

    Best video on here for Vlookups. Thanks for this great video

    • ExcelIsFun
      ExcelIsFun  3 месяца назад

      You are welcome!! Thank you for the support with your comment, Thumbs Up and Sub : )

  • jean paul banza
    jean paul banza 3 месяца назад

    Thank you! for sharing your knowledge :-)

  • Colleen Kelly
    Colleen Kelly 3 месяца назад

    Thank you so much for this video!

  • Simple Shreedhar
    Simple Shreedhar 4 месяца назад

    @31:40 Retrieving 4 Records From table,
    In that If we want to fetch only Last name and Phone Number Using I'd How to Do this??
    Last name in column 2 and phone number in 5
    by following above method I am not getting required Result..!!
    In the Phone Number column I am getting First name.
    Please help me to solve this
    Thank you

    • Simple Shreedhar
      Simple Shreedhar 3 месяца назад

      Thank you

    • dimitri300
      dimitri300 4 месяца назад +1

      Easy! You can use the function MATCH that the professor is explaining a couple of minutes later.
      You paste the following formula at Cell B18 : =vlookup($A$18,$A$4:$E$10, MATCH(B17,$A$3:$E$3,0),0).
      Then you drag the formula to the next Cell(C18), where you have the Phone Number column ('Phone' in C17 ), as you requested.
      On C18 the formula will be : =vlookup($A$18,$A$4:$E$10, MATCH(C17,$A$3:$E$3,0),0).
      The MATCH function *matches* the Column name (First, Last, Phone etc.) with the same Column name from the big table that has all data.

  • jumyshihab
    jumyshihab 4 месяца назад

    Thanks a lot

  • Leticia Lopez-Hernandez
    Leticia Lopez-Hernandez 4 месяца назад

    I have an excel file with 4 worksheets. One is the master list and the other 3 are department employee lists. Each sheet has the employee number and every department supervisor will be entering the date when an employee will be layoff. Is there and easy way to transfer this data from the department work sheets into master worksheet?Column A is the employee ID, row one is week beginning date. Managers entered a number one to mark the cell employee will be layoff.Can you help?

  • bini
    bini 4 месяца назад

    So what if you have a table that is always changing and you need to pull only certain lines of data to another sheet within the same file? So I have a table that has accepted contracts for our company. This table is always changing because jobs get scheduled and new jobs are added. I also have 3 people whose jobs are associated with. I need to make a list of only that person's jobs on a separate sheet. Can I do this with this function?

  • Mostafa Adel
    Mostafa Adel 4 месяца назад

    This is the real edutainment. Really enjoyed every single second. If your videos were to display in cinema, you'd win the Oscar everyday. May Allah increase you in knowledge.

  • Michael Ochinero
    Michael Ochinero 4 месяца назад

    Is there a way to VLOOKUP from sheet to sheet? I I may have missed it in the video.

  • eng.mohammed nazly
    eng.mohammed nazly 4 месяца назад

    To learn how to use MS Excel for beginners and advanced we introduce you this channel
    ruclip.com/channel/UCTXqwxNCcEHUbYjr76G50BA

  • Usurlia Benjamin
    Usurlia Benjamin 4 месяца назад

    This is great!!

  • Divya khare
    Divya khare 4 месяца назад

    It's simply brilliant. One must go through every bit of it for maximum benefit. Thanks for this amazing video.

    • ExcelIsFun
      ExcelIsFun  4 месяца назад

      You are welcome!

  • Eric Ono
    Eric Ono 5 месяцев назад

    Hey! I have some doubts in the "Full record" example.
    1) Why it does not work if i use "TRUE" as "range_lookup argument" in the "Numbers above column header" function? It should work as well, as we are using data validation, does not it?
    2) Once I heard from one of your videos that the array must have the values in ascending order so that the lookup function can work properly, and that is not the case. How one can explain that?
    Best regards from Brazil, and thank you so much for this awesome open lessons!

  • FrancisTram
    FrancisTram 5 месяцев назад

    Nice video course, thanks for sharing :-) !

  • Zoya Sharma
    Zoya Sharma 5 месяцев назад

    Thank you so much. The video is awesome! Thanks a lot. God Bless !!!

  • krishna mohan
    krishna mohan 5 месяцев назад

    iwant H lookup

  • Leonardich30
    Leonardich30 5 месяцев назад

    how to vlookup if my vlookup data is in the last column and I need to retrieve the data from 1st, 2nd columns for example?
    how to do vlookup on cells with formulas in it?
    good videos to make.

  • Ricardo Santos
    Ricardo Santos 6 месяцев назад

    Thank you a lot for your videos for sure the best explanations!
    Can you tell me or redirect me to a Vlookup video that teaches how to consider an array of numbers (in this case are G/L Accounts) and returns the total sum (that are in another sheet) of the these accounts? It would help me a lot.
    Thanks in advance.

  • pdo-samar hem8
    pdo-samar hem8 6 месяцев назад

    Excellent Video on Vlookup functions.

    • ExcelIsFun
      ExcelIsFun  6 месяцев назад

      Glad you like it! : )

  • Isabella L
    Isabella L 6 месяцев назад

    Very powerful and helpful video! Thank you so much.

    • ExcelIsFun
      ExcelIsFun  6 месяцев назад

      You are welcome so much!

  • Cyndi Barber
    Cyndi Barber 6 месяцев назад

    I've gone over the vlookup using the named ranges and noticed, first of all, that my computer uses FN F3 instead of just F3. Next, I can't seem to use the named ranges without getting the N/A error. It looks right, but I can't figure out what's wrong =VLOOKUP(B27,vtable,4,FALSE)

  • Sudhir Bhardwaj
    Sudhir Bhardwaj 6 месяцев назад +1

    If someone asks me 'What should I do to learn Excel to an expert's level ?'.................
    I suggest 'Excel is Fun is the best RUclip Channel of all time'
    Sometimes it feels like as if you have created Excel
    Hats Off man.....you are really a great teacher

    • ExcelIsFun
      ExcelIsFun  6 месяцев назад

      Thank you for your very kind words!!! And thank you for your support with comment, Sub and Thumbs Up : )

  • Echo Chen
    Echo Chen 6 месяцев назад

    Thanks so much, it is very helpful, good teaching, esp with workbook provided to practice. I will learn all thing about excel from you. Thank you very very much. I watched many videos, but yours is the most helpful one for me.....

    • ExcelIsFun
      ExcelIsFun  6 месяцев назад

      I am glad that they are helpful! That is why I post them all. Thanks you for your Sub and Thumbs Up and comment on each video as support : )

  • Oliver France
    Oliver France 6 месяцев назад +1

    Using this in 2017, Thanks bro

    • Oliver France
      Oliver France 6 месяцев назад

      Cool bro thanks. Quick question. @52:57 why does the vlookup formula bring back a return as text when running the trim function?

    • ExcelIsFun
      ExcelIsFun  6 месяцев назад

      I don't have cripto, I only have Pay Pal Donate:
      ruclip.com/user/ExcelIsFunabout
      Thank you!!!!!!

    • Oliver France
      Oliver France 6 месяцев назад

      I also got a job using this by the way...... Do you have a Bitcoin or another crypto currency address I am able to donate to ?

    • ExcelIsFun
      ExcelIsFun  6 месяцев назад +1

      You are welcome! Thanks for your support with comment, Sub and Thumbs Up : )

  • Darice Taipalus
    Darice Taipalus 6 месяцев назад

    jam packed with info. I thought I knew Excel, bwhahahahha

    • ExcelIsFun
      ExcelIsFun  6 месяцев назад

      Glad you liked the info : )

  • Mateusz K.
    Mateusz K. 6 месяцев назад

    31:27 I wonder why for an expandlable range in COLUMNS function you used =COLUMNS($B18:B18)+1 instead of =COLUMNS($A18:B18) - this would give you value we want - 2, without adding anything to the formula.

  • Dilshod
    Dilshod 7 месяцев назад

    Excellent

  • Adiba Muminova
    Adiba Muminova 7 месяцев назад

    Thank you for the invaluable video!

    • ExcelIsFun
      ExcelIsFun  7 месяцев назад

      You are welcome! Thanks for the Sub and Thumbs Up : )

  • shahnawaz shaikh
    shahnawaz shaikh 7 месяцев назад

    Very nice video you have cleared all concept very well awesome video.

    • ExcelIsFun
      ExcelIsFun  6 месяцев назад

      Glad it helped!

  • Trang Le
    Trang Le 7 месяцев назад

    I'm wondering why you used VLOOKUP(A17, B6:D10,3) at 22:54. I did the same and got N/A. I changed to (A17, A6:B10,4) and got the desired value.

  • Nicole Allen
    Nicole Allen 7 месяцев назад

    thank you for this!!!! I forgot to add the addresses to a monthly spreadsheet I create for over 8k members, I was able to add the address in less then 5 Mins!!!! great stuff !!! watched about 5 minutes of the video because im very impatient lol but it was a very useful 5 mins lol keep up the amazing work!

  • Michael Zeng
    Michael Zeng 7 месяцев назад

    58:36. why include A7??

  • Sunil Kumar
    Sunil Kumar 7 месяцев назад

    hi ,
    do we have a video tutorial on how to use vlookup function when the data is filtered. .
    i need the one

  • ABlue Faic
    ABlue Faic 7 месяцев назад

    really learned a lot. Thank you so much!!

    • ExcelIsFun
      ExcelIsFun  6 месяцев назад

      You are welcome so much!

  • Naresh Fernando
    Naresh Fernando 8 месяцев назад

    Thank you so very much for this tutorial. Exactly what I needed to know. Cheers!

    • ExcelIsFun
      ExcelIsFun  8 месяцев назад

      You are welcome! Thanks for the Sub and Thumbs Up : )

  • J.C. Nizeyimana
    J.C. Nizeyimana 8 месяцев назад

    Sincerely appreciate it.

    • ExcelIsFun
      ExcelIsFun  8 месяцев назад

      Thanks for your support with Sub and likes : )

  • killax1000
    killax1000 8 месяцев назад

    These videos are invaluable. I've gone from office lackey temp to office Excel guru watching your videos. Came to figure out how to use VLOOKUP to find a way to search multiple parameters and the answer is make them into 1 parameter! Incredible. =VLOOKUP(critera1&2&3etc,CHOOSE({1,2},column1&2&3etc,resultcolumn),2,0)

  • Betul Champlin
    Betul Champlin 8 месяцев назад

    Hi, can you please help me find the workbook? I can not find it in the link below for a reason. I appreciate the help.Download workbook: people.highline.edu/mgirvin/ExcelIsFun.htm

    • ExcelIsFun
      ExcelIsFun  8 месяцев назад

      Yes! I have added the direct links to the files below the video!!!! Thanks for your Sub and Like on each video : )

  • Amal Malenki
    Amal Malenki 8 месяцев назад

    Your videos are simply awesome and so simple to understand and navigate through. Thankyou Sir!

    • ExcelIsFun
      ExcelIsFun  8 месяцев назад

      You are welcome! Thanks for your Sub and Likes : )

  • PURVANG PANCHAL
    PURVANG PANCHAL 8 месяцев назад

    Hey this is one very good tutorial i have seen in youtube

  • Sylvester Smith
    Sylvester Smith 8 месяцев назад

    You are an Excel god!!!!

  • Simple & Rational
    Simple & Rational 8 месяцев назад

    Never heard about the CHOOSE formula before. Practical examples with clear explanation. Great job!

  • Jennifer Hill
    Jennifer Hill 9 месяцев назад

    I landed a great job and one of the key things I needed to learn was V-lookup. I had excel opened up, while I worked my way through your course. Thank you for helping me land a great job and I will keep watching as long as you are here to stay. You're the BEST!!!

    • Jennifer Hill
      Jennifer Hill 8 месяцев назад

      Question, when I click the link to work on them, should I follow the video as well? I want to watch the video and work on the spreadsheet as well. Please provide more information.

    • ExcelIsFun
      ExcelIsFun  9 месяцев назад +1

      Congratulations on the new job! Yes, I am here to saty. I will keep posting! Thanks for the Sub and Thumbs Up on each video : )

  • Aminah Butt
    Aminah Butt 9 месяцев назад

    i luv watching ur videos..... so much to learn from them....thank you

  • Dani Emm
    Dani Emm 9 месяцев назад

    This was SO helpful!!! Thank you!!

    • ExcelIsFun
      ExcelIsFun  9 месяцев назад

      You are welcome! Thanks for the Sub and Thumbs Up : )

  • yudhishther sharma
    yudhishther sharma 9 месяцев назад

    can a formula give me following result
    i have a unique number R1, check it in a coloumn if R1 is in that coloumn then a corresponding value, if no then check it in a coloumn of another sheet2 and give me corresponding value, if no then check it in col of sheet3....

  • shivam mittal
    shivam mittal 9 месяцев назад

    Last one is not working in the Excel 2013 or am i doing it wrong?

  • Shelley Maxwell Channel
    Shelley Maxwell Channel 10 месяцев назад

    My dream is to take all your classes, I hope they can be available online. You are such a good teacher!

    • ExcelIsFun
      ExcelIsFun  9 месяцев назад

      All my classes are for free at RUclip. You can look through the playlist section and choose which one you would like. or tell me what class you would like to study and I can post the link here. What class you would like to study: Excel Basics? Intermediate and Advanced Excel, Office? Business Math? Statistics? Finance?

  • gwa56
    gwa56 10 месяцев назад

    Best video explanation I've seen on RUclip thus far! Thank you.

  • Bitcoins
    Bitcoins 10 месяцев назад

    Sir, your video tutorials are very amazing! I'm currently making a medicine inventory worksheet. I'm trying to figure out how to update my inventory everyday from my dispensed medicines. Most of the medicines have the same names but different serial numbers. I need to know which medicines will be expiring before 3 months from expiration, almost finished stocks, auto updated medicine list with day-to-day numbers to how many being dispensed during that day. Thanks sir!

  • pauline scharf
    pauline scharf 10 месяцев назад

    I am sooo happy that i came across this video !!!!T-H-A-N-K-Y-O-U !!!! This is the best you tube video ,

    • ExcelIsFun
      ExcelIsFun  10 месяцев назад

      Glad the video helps! Thanks for the Sub and Thumbs Up : )

  • Patrice Thomas
    Patrice Thomas 10 месяцев назад

    Thank you very much buddy. Thank you for your honesty, making it easy to locate the excel file on your web. I very much appreciate that and for taking the time to teach it.

    • ExcelIsFun
      ExcelIsFun  10 месяцев назад

      You are welcome! Thanks for the Sub and Thumbs Up : )

  • Leon Chan
    Leon Chan 10 месяцев назад +1

    Being proficient in Excel is not difficult. However, teaching it the way you do, that is a gift. Your way of explaining and demonstrating these concepts are the best I've come across. I never thought I'd say this, but learning Excel is actually fun. Very big thank you!

    • ExcelIsFun
      ExcelIsFun  10 месяцев назад

      Very Big: You are welcome!!!

  • Jeff Bennett
    Jeff Bennett 10 месяцев назад

    I'm very new to VLOOKUP/Pivot tables and have to learn both for work. I am also pretty amaneur with Excel. Is Excel 2013 and now Excel 2016 fundamentally different in its features, or is this video still 100% relevant? Thanks

    • Jeff Bennett
      Jeff Bennett 10 месяцев назад

      Thanks for the response!

    • ExcelIsFun
      ExcelIsFun  10 месяцев назад +1

      Thanks for the Sub and Thumbs Up : )

    • ExcelIsFun
      ExcelIsFun  10 месяцев назад +1

      Excel 2013 and 2016 are very similar. The main differences are the upper end Big Data Analysis features, which do not affect VLOOKUP and Standard PivotTables features. Especially the VLOOKUP, where there is zero difference. This video made back in 2012 is 100% relevant.

  • Joey Sunshine
    Joey Sunshine 10 месяцев назад

    Man this video is giving me life! Thank you a million and one times!

    • Joey Sunshine
      Joey Sunshine 10 месяцев назад +1

      Least I could do. Cheers!!

    • ExcelIsFun
      ExcelIsFun  10 месяцев назад +1

      You are welcome a million and one times! Thanks for the Sub and Thumbs Up : )

  • Sardar Abid
    Sardar Abid 11 месяцев назад

    i have big problem to used excel formules

  • hrmon pagrigs
    hrmon pagrigs 11 месяцев назад

    Thanks a lot Sir, Its very comprehensive. Indeed a big help :)

    • ExcelIsFun
      ExcelIsFun  11 месяцев назад

      You are welcome!

  • nawal abdullahi
    nawal abdullahi 11 месяцев назад

    was helpful in my computer science hw, thanks:)B)

    • ExcelIsFun
      ExcelIsFun  11 месяцев назад

      You are welcome!

  • Mohamed haj hasan
    Mohamed haj hasan 11 месяцев назад

    Thanks for this awesome explanation for the Vlookup functionality, it was helpful appreciate your effort.

    • ExcelIsFun
      ExcelIsFun  11 месяцев назад

      You are welcome!

  • jacky chawla
    jacky chawla 11 месяцев назад

    will u please make a video on custom formatting&array advance

  • jacky chawla
    jacky chawla 11 месяцев назад +1

    one of the most powerful concept by anyone on youtube invincible !!!!!!!!!!

    • ExcelIsFun
      ExcelIsFun  11 месяцев назад +1

      Thank you for the kind words : )

  • Mili Biswas
    Mili Biswas 11 месяцев назад

    Now I can say, i know this function confidently in my dream job interview! thanks!

    • ExcelIsFun
      ExcelIsFun  11 месяцев назад

      Awesome! : ) Good luck with the interview!

  • Cathe Gutierrez
    Cathe Gutierrez Год назад

    This is awesome. I almost could not find you videos again

    • ExcelIsFun
      ExcelIsFun  11 месяцев назад

      I am glad that you found it again!

  • gassiusdave
    gassiusdave Год назад

    Hi ExcellsFun,
    You are an Excel GOD!!!! Thank you for your help!!

    • ExcelIsFun
      ExcelIsFun  11 месяцев назад

      Not a god, just a guy having fun with Excel : )

  • Sikarate
    Sikarate Год назад

    Hello, I wonder about "20.Partial Text Lookup: RIGHT Function", if I don't know the last "num_chars" for each ID. How can I find the way to solve this matter?
    For example Bellen-234-B25R, Carlota-345-C20R, Quad-765-Q20L >> the last num_chars = 4 digits, we can use =RIGHT(text,4) --to fix 4 in the formula, but if some ID may "Quad-765-Q20LK" >> the last num_chars is 5 digits. What is the formula we can use in this situation?
    Thanks in advance.

  • Kalpana U
    Kalpana U Год назад

    Thank you so much for the video,its really very helpful

    • ExcelIsFun
      ExcelIsFun  11 месяцев назад

      You are welcome!

  • Milan Dave
    Milan Dave Год назад

    Amazing explanation. Very useful :)

  • peacewize69
    peacewize69 Год назад

    Awesome video and I'm very glad you added the dynamic range at the end, that was one of my main questions was how to continuously update a table

  • J11 18
    J11 18 Год назад

    At 33:06, I'm a bit confused on how the ROWS function actually calls the specific data in this example. The plus 1 makes sense since it can call the next requirement since it's in order with the array we are getting the data from. But how does setting ROWS to (B$22:B22) actually call upon the needed data?

  • Online Tech Secret
    Online Tech Secret Год назад

    Thanks for making this great video............

  • Maureen Hill
    Maureen Hill Год назад

    This by far was the easiest tutorial for VLookup which I've struggled with for years LOL. Thank you for this great video! Happy Holidays!

  • Travis.H Wong
    Travis.H Wong Год назад

    How can I vlookup the answer without know the source is coming from which table?

  • Rannie Rigodon
    Rannie Rigodon Год назад

    Bravo sir.. advance Merry Christmas and Happy New Year.

    • ExcelIsFun
      ExcelIsFun  Год назад

      Happy Holidays to you too : )

  • Geana Gutierrez
    Geana Gutierrez Год назад

    Thank you!!! What a great class, I have learnt a lot!!! This is reminding me when I did visual basic with excel. I did understand everything, but I did have some questions about the choose formula. When you have to use {} or tables, I would like to know the logic behind the formula and in which more scenarios you can use it. Thank you.

  • ndelpurg
    ndelpurg Год назад

    MANY THANKS FOR YOUR GREAT WORK !

  • DJ Al-shaikh
    DJ Al-shaikh Год назад

    Can you briefly explain what does a "Case study excel base (vlookup)" means? uncle google did not help :(

  • DJ Al-shaikh
    DJ Al-shaikh Год назад

    =VLOOKUP(B100,CHOOSE(VLOOKUP(A100,$A$108:$B$110,2,TRUE),$F$101:$G$103,$F$107:$G$111,$F$114:$G$116),2,TRUE)

    • ExcelIsFun
      ExcelIsFun  Год назад

      I talked about this early in the video. TRUE (Approximate Match) is the default. If you only put three arguments, it does Approximate Match by default. Be sure it is like: VLOOKUP(A100,$A$108:$B$110,2) and not VLOOKUP(A100,$A$108:$B$110,2,)

  • DJ Al-shaikh
    DJ Al-shaikh Год назад

    in the VLOOKUP with 3 LOOKUP tables why havent u used TRUE so that u can get a percent of the nearest number.

    • ExcelIsFun
      ExcelIsFun  Год назад

      I talked about this early in the video. TRUE (Approximate Match) is the default. If you only put three arguments, it does Approximate Match by default. Be sure it is like: VLOOKUP(A100,$A$108:$B$110,2) and not VLOOKUP(A100,$A$108:$B$110,2,)

  • DJ Al-shaikh
    DJ Al-shaikh Год назад

    thanks so much for the very useful tutorial.. i am having my case study test for job interview and they told me it is based on vlookup function.. hope do well... may I ask you if you can provide us with the sample spreadsheet you used in your tutorial? Cheers

    • ExcelIsFun
      ExcelIsFun  Год назад

      Yes, click link below video and go to VLOOKUP Week section.

  • riyam ibrahim
    riyam ibrahim Год назад

    thank you so much.

  • fmanaruto
    fmanaruto Год назад

    I love you bro

  • Deepak Kumar
    Deepak Kumar Год назад

    It's amazing for the Beginners, Thank u sir

  • FPrimeHD
    FPrimeHD Год назад +1

    You make me want to go back to college and take a class again.