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


  • Опубликовано:  5 лет назад
  • Download Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/VLOOKUP-SHARK-WEEK-DoawnloadableWorkbook01-Start.xlsx
    Download Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/VLOOKUP-SHARK-WEEK-DoawnloadableWorkbook01-FINISHED.xlsx
    Entire Page with All Files for All Videos: https://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:8:3
  • Тэги для этого Видео:  Excel  2003  2007  2010  VLOOKUP  lookup  HLOOKUP  COLUMNS  ROWS  MATCH  CHOOSE  LEFT  SEARCH  MID  RIGHT  TRIM  Tax  Shark Week  VLOOKUP SHark Week  Mike Girvin  excelisfun  Highline Community College  Defined Name VLOOKUP  Slaying Excel Dragons  Lookup on different sheet  Lookup different workbook  Two lookup values  two lookup columns  Join two lookup values  Partial Text lookup  lookup left  CHOOSE function  How To Use Excel VLOOKUP Function  VLOOKUP basics  Excel VLOOKUP Function  

Комментарии: 1 750

  • pdo-samar hem8
    pdo-samar hem8 1 день назад

    Excellent Video on Vlookup functions.

    • ExcelIsFun
      ExcelIsFun 1 день назад

      Glad you like it! : )


  • Isabella L
    Isabella L 2 дня назад

    Very powerful and helpful video! Thank you so much.

    • ExcelIsFun
      ExcelIsFun 1 день назад

      You are welcome so much!


  • Cyndi Barber
    Cyndi Barber 3 дня назад

    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 8 дней назад +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 YouTube 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 8 дней назад

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


  • Echo Chen
    Echo Chen 20 дней назад

    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 20 дней назад

      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 24 дня назад +1

    Using this in 2017, Thanks bro

    • Oliver France
      Oliver France 23 дня назад

      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 23 дня назад

      I don't have cripto, I only have Pay Pal Donate:

      https://www.youtube.com/user/ExcelIsFun/about

      Thank you!!!!!!


    • Oliver France
      Oliver France 23 дня назад

      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 24 дня назад

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


  • Darice Taipalus
    Darice Taipalus 25 дней назад

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

    • ExcelIsFun
      ExcelIsFun 1 день назад

      Glad you liked the info : )


  • Mateusz K.
    Mateusz K. 25 дней назад

    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 1 месяц назад

    Excellent

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

    Thank you for the invaluable video!

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

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


  • Don Johnson
    Don Johnson 1 месяц назад

    Pretty cool, pretty neat

    • ExcelIsFun
      ExcelIsFun 1 день назад

      Glad it was cool for you : )


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

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

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

    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 1 месяц назад

    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 1 месяц назад

    58:36. why include A7??

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

    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 1 месяц назад

    really learned a lot. Thank you so much!!

    • ExcelIsFun
      ExcelIsFun 1 день назад

      You are welcome so much!


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

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

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

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


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

    Sincerely appreciate it.

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

      Thanks for your support with Sub and likes : )


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

    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 2 месяца назад

    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: http://people.highline.edu/mgirvin/ExcelIsFun.htm

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

      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 2 месяца назад

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

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

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


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

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

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

    You are an Excel god!!!!

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

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

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

    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 2 месяца назад

      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 3 месяца назад

      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 3 месяца назад

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

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

    This was SO helpful!!! Thank you!!

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

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


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

    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 3 месяца назад

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

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

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

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

      All my classes are for free at YouTube. 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 4 месяца назад

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

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

    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 4 месяца назад

    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 4 месяца назад

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


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

    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 4 месяца назад

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


  • Leon Chan
    Leon Chan 4 месяца назад +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 4 месяца назад

      Very Big: You are welcome!!!


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

    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 4 месяца назад

      Thanks for the response!


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

      Thanks for the Sub and Thumbs Up : )


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

      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 4 месяца назад

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

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

      Least I could do. Cheers!!


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

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


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

    i have big problem to used excel formules

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

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

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

      You are welcome!


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

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

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

      You are welcome!


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

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

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

      You are welcome!


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

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

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

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

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

      Thank you for the kind words : )


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

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

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

      Awesome! : ) Good luck with the interview!


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

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

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

      I am glad that you found it again!


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

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

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

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


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

    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 6 месяцев назад

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

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

      You are welcome!


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

    Amazing explanation. Very useful :)

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

      Glad it helped!


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

    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 6 месяцев назад

    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 7 месяцев назад

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

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

    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!

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

      You are welcome!


  • Travis.H Wong
    Travis.H Wong 7 месяцев назад

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

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

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

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

      Happy Holidays to you too : )


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

    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 7 месяцев назад

    MANY THANKS FOR YOUR GREAT WORK !

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

      You are welcome!


  • DJ Al-shaikh
    DJ Al-shaikh 7 месяцев назад

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

  • DJ Al-shaikh
    DJ Al-shaikh 7 месяцев назад

    =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 7 месяцев назад

      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 7 месяцев назад

    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 7 месяцев назад

      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 7 месяцев назад

    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 7 месяцев назад

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


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

    thank you so much.

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

      You are welcome!


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

    I love you bro

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

      Glad the videos help!


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

    It's amazing for the Beginners, Thank u sir

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

      You are welcome!


  • FPrimeHD
    FPrimeHD 8 месяцев назад +1

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

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

      Glad you like it!


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

    Hi!
    It's really helpful, but please check this ==> in section VLOOKUP with 3 lookup tables: CHOOSE Function ( 53:20 min)
    If we put in the fourth table any other value than 1 , 2 or 3 the result simply don't work, So kindly explain why is that??
    Thanks

  • Amilia Joan Fernandez
    Amilia Joan Fernandez 8 месяцев назад

    Thank you so much, this video has helped me get through excell test for my job interview. I can;t express enough how grateful i am

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

      You are welcome!


  • E. S.
    E. S. 8 месяцев назад

    You have the best Excel videos, and have a gift for making complicated functions seem easy.  Thank you!

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

      You are welcome!


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

    Pls, explain to me why choose B12 in vlookup example

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

    Thank you so much ,you are awesome!!

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

      You are welcome!


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

    Excellent Video...thanx a lot...:)

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

      You are welcome!


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

    It's very useful. thanks very much.

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

      You are welcome!


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

    Great Help!! Thorough and good to view more detailed overalaying scenarios! Thanks!!

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

      You are welcome!


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

    This is awesome! Thanks so much!!

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

      You are welcome!


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

    Very useful.Learned a lot.

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

      Glad you like it!


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

    Great videos dude.. I need one help. Let say i have 100000 row with multiple information now i have to pull all the data from that table selecting specific id another sheet/worksheet. Let say i have apple in first column i want pull all 1000 rows that is inside 100000 row data table in random order and pull it. Hope you get it. Please respond.

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

    It's awesome video

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

      Glad you like it! Thanks for Thumbs Up! : )


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

    Host has Expertise in Excel and has a good remembrance of Shortcuts which is awesome.

    Sir, may know how you could remember so many shortcuts ?

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

      Practice, practice, practice. That's it. : )


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

    I enjoyed watching this video.
    Thanks for educating the community.
    May know what software is used to record this video?
    Thanks a bunch

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

      You are welcome a bunch! I use Camtasia.


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

    nice technics of vlookup formula

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

      Glad you like it!


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

    You save me every time! Thank you for all these videos!

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

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


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

    I didn't understand quite well why you should click ctrl+shift+enter when using the CHOOSE function for table array? What does this keyboard shortcut do? What is exactly an array formula?

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

      ExcelIsFun thanks for a quick reply and a thorough explanation! Your channel is awesome, keep it up :)


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

      Ctrl + Shift + Enter signals to Excel that the formula is not a normal formula, but instead it is an Array Formula. Array Formulas act on arrays of items rather than single items. If CHOOSE needs to pull two items simultaneously with {1,2}, it is not longer a normal formula, it is an array formula.


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

    Wow, 4 years later and this video is still the hottest thing out. I really appreciate this so much. I was afraid that the video might be to old for the Excel 2010 version I'm on but it works like a charm. Your shortcut keys are out of this world. Need a lesson on all the shortcuts you know lol.

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

      Glad you like the video!


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

    thanx

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

      You are welcome!


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

    Hi,

    I want the workbook of this video and i am not able to find this. Please provide me the link from where I can download the workbook!!

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

      You are welcome!


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

      Thanks!! You are Awesome ;)


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

      Click this link: https://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


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

    I can't find the workbook you are using

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

      Thanks for the quick response.. And your video was very helpful.. Thanks a lot


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

      Click this link: https://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


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

    very useful and easy to learn, thank you

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

      You are welcome!


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

    I can't download a workbook :/ Can you help me because it's seems like a very good explanation. Pls send me link to download a workbook :)

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

      Click this link: https://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


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

    awesome

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

      Glad you like it!


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

    This guy is cancer in anus

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

    Way easier than I previously thought! thanks a lot!

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

      You are welcome!


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

    Thanks a lot for this video!
    You truly do a great job.

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

      Glad you like it!


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

    Very useful

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

      Glad it helps!


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

    Have a quick question: at 27.00 you discuss utilizing ranges from different files... If the data from those respective (pull from) files are altered, will the outcomes on the spreadsheets you are working on also alter? In other words, are the tables all HOT, indefinitely? Or can the data be locked in never to alter, even if those reference tables are changed? (Hope my question makes sense. Thanks.)

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

    I have a question. I have a list of data numbers ex ,10 set of numbers  on the left and boxes on the right.The left are customers and the right  are boxes  of cargo , if the total of the cargo is 3200 pies how can I ,by tiping the first customer  it can fill other customers for  a total of 3200,or the colsest number to fill the truck.

                               


      457
      1820


      447
      463


      451
      583


      466
      709


      468
      1011


      470
      970


      473
      462


      497
      1249


      552
      1000


       125
       1200

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

    hi
    can i get ur contact mail id??

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

    Thank you so much!

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

      You are welcome!


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

    it seems that the link is not working!!

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

      I just found the link: https://people.highline.edu/mgirvin/ExcelIsFun.htm


Seo