Lookup Formulas Training Series – Getting Started with VLOOKUP (1 of 3)

The Lookup Formulas Training Series Part 1:

The 5 Essentials to Getting Started with VLOOKUP

Download the file used in this video:

Getting-Started-with-VLOOKUP-Excel-Campus.zipDownload

https://www.excelcampus.com/filedownload/VLOOKUP-Essentials-Guide-Excel-Campus.pdf

Lookup Formulas Training Series

Video 1

Intro to VLOOKUP:The 5 Must Know Essentials

Video 2

Lookup Formula Errors:How to Prevent Critical Errors

Video 3

INDEX & MATCH:An Alternative to VLOOKUP

 

What Are You Going To Use VLOOKUP For?

Please leave a comment below with your answer, and any questions.  Thanks!​

1,071 comments

1 … 6 7 8 9 10 … 17

Your email address will not be published. Required fields are marked *

  • Jon:

    I’ve seen numerous instructional videos on VLOOKUP. And, while I am very comfortable using the function in many different applications, this was by far the easiest video to follow. Some instructors take a more “lofty” approach… making it difficult to interpret. Your video, on the other hand, was extremely well produced, informative and fun to follow.

    I look forward to seeing the next 2 videos.

    Reply

  • I have searched and watched YouTube videos re Vlookup and I think this video is the best out there. Using VLOOUP on my databases….thank you for this!

    Reply

  • Jon, Thanks for your time and dedication on excels based on which workers like me can grow their skills while working in the competitive environment

    Reply

  • Dear Jon,

    I really wanted to learn Vlookup for Mark to Market Valuation of Financial Securities with daily closing prices.

    Thanks Jon for such a good lesson.

    Reply

  • Jon,

    Nice video explanation of v-lookup. I had a good grasp of v-lookup but nice to have a refresher. I look forward to Index and match which will help me a lot. Any idea when video 2 and 3 will be available?

    Thanks,

    Gary

    Reply

    • Hi Gary,
      Thanks for the nice feedback. I send the videos a few days apart. You should have received both by now. Sorry I’m a bit backed up on blog comments. Let me know if you have any questions.

      Reply

  • Excellent! Really good lesson + tips. Thank you for taking the time to not only simplify, but clarifying with such detail a better understanding of VLookup. Upon looking, I was not able to locate a link to the next Video in this series. I am looking forward to learning more… Would you happen links for Video 2 and 3 if they are currently available?

    Reply

    • Hi Sandra,
      Thank you for the nice feedback. My apologies for not getting back sooner. I send the videos a few days apart. You should have received them by now. Let me know if you did not get them. Thanks!

      Reply

  • Very useful for a project I’m doing with Sales Representative that will get at specific revenue to get bonus, and also percentage in commission…

    Really make this formula make so easy and simple…

    Thanks Jon

    Reply

  • Your videos are by far the easiest ones to follow and I love that you use relatable examples!

    Vlookups are helping me automate aspects of payroll processing and compensation analysis.

    Thank you!

    Reply

    • Hi Leah,
      Thank you so much for the nice feedback. I’m happy to hear the videos are helping save you time. Awesome! 🙂

      Reply

  • Jon,
    I have 95 students in an Excel class. Is there a way I can share your videos with my students?
    Loretta

    Reply

    • Hi Loretta,
      Thank you for contacting me. Yes, you can absolutely share the videos. I really appreciate your support and hope this helps your students. Thank you! 🙂

      Reply

  • JON I WOULD LIKE TO FIND THE TIME OF DAY THAT A STOCK PRICE WAS AT ITS HIGH AND LOW . GOOGLE FINANCE HAS A INTRADAY HISTORICAL STOCK DOWNLOAD FOR 15 DAYS OF DATA FOR EXCEL . THE WEB SITE TO GET THE INTRADAY STOCK DATA IN EXCEL http://investexcel.net/free-intraday-stock-data-excel/ AND I WOULD LIKE TO KNOW IF THE OPEN TODAY WAS HIGHER THEN THE OPEN AND CLOSE OF YESTERDAY AND TODAY CLOSE WAS HIGHER THEN TODAY OPEN AND ALSO THE CLOSE AND OPEN OF YESTERDAY BY CLORING THE CELL GREEN FOR HIGHER OR RED FOR LOWER . CAN IT BE DONE WITH VLOOKUP AND PUT ON A PIVOT TABLE WITH A QUERY TO GOOGLE INTRADAY HISTORICAL FINANCE ,SO I JUST TYPE THE STOCK SYMBOL INTO A PIVOT TABLE TO GET THE DATA.
    THANK JON
    JOHN PYSKATY
    JON I AM 75 AND HAVE VERY LITTLE COMPUTER SKIL

    Reply

  • Hi Jon..

    This was a great video, VLOOKUP seemed so difficult for me to learn, now I see (thanks to you) that it’s easy to understand and your video’s are easy to learn from, looking forward to learning more from you..!

    Reply

  • Hi Jon,
    I am much happier than Andy.
    V-Lookup is critical to my task in the office
    Thanks for improving my excel.

    Reply

  • Thank you

    The vlookup would be used to look up the prices of the items I want to order and use the (hold the alt) alt equal to get the sum of entire order.

    Great lesson!

    My question is, how do I remember all this info? And what is the trick of saving all this date in one place with the difference lesson one, lesson two and so on.

    Also I like what I learned, ie absolute and relative.

    Thank you once again, Nancy

    Reply

    • Thank you Nancy! The trick to remembering it is really just using it in your everyday work. I think you will find a lot of uses for VLOOKUP. I hope that helps.

      Reply

  • I am a long-time VLOOKUP user, but I watched this to pick up a time-saving tip or two. (I wasn’t disappointed.) I use VLOOKUP for everything; now I am going to broaden my use of MATCH and INDEX.

    Thanks for a great series of information.

    Reply

  • I don’t have a pressing need for vlookup, I would just like to understand it, and other Excel subjects, better.

    I’ve learned Excel just by reading and looking up whatever I need to get a task done. I love the way you cover material that is typically boring, in a way that is thorough, yet easy to follow and even enjoyable! I look forward to more of your videos.

    Reply

  • Hi John, I found you on you tube to help me with study for a job interview your video was helpful for such short notice, though I didn’t get the job . I am using your support to study up on pivot , vlookup tables and more. thank you for an easy to use guide as I know were I went wrong I didn’t do vlookup in caps in the formula. thanks again George

    Reply

  • I used VLookup for multiple projects, wanting to find ways to have it look at two columns of data to match, and bring back results of another column. Matching Patient name and appointment time from schedule to invoice table. Currently do in multiple steps, and manual looking.

    Reply

  • Can VLookup be used in a macro or is there a VB version of Vlookup? For instance Assume I have a worksheet that has dates (a date for all 365 days of a year) in column B and messages in column C (a different message for each day of the year). Further assume, I want an Auto_Open Msgbox that will, based on whatever date is today or now, state the message that is in column C. So if the date in B2 is 1/2/17 and the message in C2 is “Have a great day” – when I open the workbook the Msgbox will say “Have a great day.” Otherwise my macro would be
    Sub Auto_Open()
    If Date = (#1/2/2017#) Then
    MsgBox “Have a great day!.”
    End If
    If Date = (#1/3/2017#) Then
    MsgBox “Everything you need will come to you at the perfect time.”
    ‘and so on for each day of the year. A VLookup type function would reduce the size of the Macro and updating the table, vs changing the year for each date in the macro, would be easy to update in subsequent years.

    Reply

    • Hi Rebecca,

      My apologies for not getting back sooner. Yes, we can use the worksheet functions like vlookup in VBA. Here is the code to lookup a date in column A and return the value in column B.

      sMessage = WorksheetFunction.VLookup(CLng(Date), Worksheets("Sheet1").Range("A1:B10"), 2, False)

      For the lookup value we can use the Date function that will return today’s date. I wrapped it in the CLng function to convert the date to a number. Column A contains dates, but the vlookup function needs to lookup the numeric value of the date in order to find a match. Here is an article on how the date system works in Excel for more details.

      I hope that helps get you started. Please let me know if you have any questions. Thanks!

      Reply

  • I need to do vlookup between very large excel data sets (more than 100,000 records) in 2 separate workbooks. Any guidance would be very welcome.

    Reply

  • I have u-tubed so many excel and V lookup in the past and this video in such a short amount of time gave me a better understanding and great tips to follow. I will be looking forward to seeing more from you. Thank you so much!!

    Reply

  • I want to use this feature in a project tool to be able to report on project progress and project staff time spent – all in one spreadsheet for multiple projects. When a particular project is defined by a unique number, I hope to be able to pull information from the various project leaders in one report to management on the general consumption of hours and economics as well as information on progress.
    It’s not as much as sales figures or simple phone lists. I can not use a project management tool, because input from project managers drawn from the company’s SAP ERP system.
    It is very good that you use a clear and precise language, since I’m not so good at English terminology.

    Reply

  • To look up start dates and employees details and more.
    I love the way you make it sound so easy, and it is when you know how!
    Cheers Tony

    p.s. I don’t use excel half enough but it’s still n intriguing program

    Reply

  • Another great video! Love your simple approach to breaking down powerful Excel tools. I’m using Vlookup to combine data from 3 different sources for a master sheet to drive a pivot table/dashboard (also learned from your Pivot Table video). Thanks and looking forward to future videos!

    Reply

  • I am using a lot on excel at work and thanks to your excel campus, not only that I can look up everything I need easily at anytime with no cost but also you have made all your lessons so easy to grasp. I have googled a lot of excel trainings online and never have I come across as easy as yours.
    Thank you so much for all your excel free trainings. Really do appreciate them.

    Reply