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 … 3 4 5 6 7 … 17

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

  • Thank you Jon for your great videos, I am trying to learn Vlook ups in order to get employment.

    Reply

    • Thanks Lisa! I wish you the best with your job search. Knowledge of the lookup formulas will definitely help impress employers.

      Reply

  • I’m working my way to a MOS in Excel and plugging up the holes in my knowledge. You got 2 of them in this tutorial. I’m using VLOOKUP to return regions based on store identification. My lookup array is a named range on another tab to keep my report from looking cluttered.

    Looking forward to the error video! Right now I’m facing a whole bunch of #N/As in that lookup. Might have something to do with some ids being numbers and some text. Setting all to general doesn’t seem to help.

    Your site is bookmarked for my lunchtime reading!

    Reply

    • Hi Barbara,
      Sorry to not get back to you sooner. I hope you got your errors resolved. And thanks for making me part of your lunchtime! Let me know if you have any questions. 🙂

      Reply

  • I am a data analyst and I need to know Vlookup to help match and track our day to day customers from those in the master EDS.Thanks for the great video.

    Reply

  • Hi Jon,
    Thanks for this webpage.
    I really apreciate your work; it´s very useful.
    Your videos are amazing and I look forword the next videos.
    Grettings
    Jorge Costa

    Reply

  • I want to use vlookup to workout manufacturing cost variance and manufacturing recovery. Also to be able to use it to track error.
    However, I must say you are really doing a great job.

    Many thanks
    Sam.

    Reply

  • I’m not sure what I will use VLOOKUP for yet, but just in the process of learning what Excel can do so I can say “Sure!” to my boss when he says, “Can you write a report to [do some amazing tasks]?” Currently I want to create a report to pull data from one customer DB then copy to another. I’ve had many requests by business owners who have built their customer database and now want to keep in contact using a greeting card system. They don’t want to manually recreate the DB but want to do a SAVE as .csv to use in another system.

    So… that’s a long-winded way of saying “clueless!” I’m excited to learn more!

    Reply

    • Haha thanks Tricia! Well I’m excited that you want to learn more, and have an open mind about it. That will take you along way with learning Excel.

      Thanks again! 🙂

      Reply

  • Hi Jon,

    I need to analyze demographics to perform workforce analytics for my client. I have a huge spreadsheet and need to be able to find data quickly to perform calculations. This tutorial will come in handy. I love you classes. Very easy to follow.

    Thank you

    Reply

  • Hi Jon,
    Thanks for the great videos! Very helpful and easy to use right away. I’m going to need the Vlookup in my new job for large data analyses.
    Regards,
    Dessy

    Reply

  • Hi Jon

    Really enjoyed the 5 Essentials to VLOOKUP.

    Similar to Lisa I’m looking to brush up on more advanced excel skills to open up job opportunities.

    I’ll be sure to add VLOOKUPs to my box of tricks to speed up how I work with data

    Reply

    • Thanks Trevor! VLOOKUP is a great skill to add to your toolbox. Most employers are looking for people with these skills, and a little vlookup knowledge goes along ways in job interviews… 🙂

      Reply

  • Had discovered you at my previous employers through On Line Hub. Now in transition and building a home library to stay sharp on all things Excel and VBA. Love the videos and cheatsheets and appreciate the simplification of your training.

    Reply

    • Thanks Prescott! It’s great to have you here, and I’m excited you are learning so much about Excel. 🙂

      Reply

  • I have lived on an island for a year and am now looking for employment back in the states. Have to take an exam before they’ll look at my resume on EXCEL Vlookup and pivot tables. Your videos are wonderful. I was certified on 2013 and this helps refresh my memory and learn the differences in 2016. I am also looking forward to the error video.

    Reply

    • Wow that island living sounds awesome Shari! Welcome back! 🙂

      I’m happy to hear you are enjoying the videos and learning so much about Excel. Employers are definitely looking for people with these skills. Thanks again and best of luck with the job search.

      Reply

  • Great videos. I’ll be creating a workbook to track and analyze sales for our on-line store.
    I’m hoping to use vlookup to enable me to create a dashboard and sliders to make the workbook easy for others to navigate.

    Reply

  • Another great video & thanks for the reference sheet – exactly what I was looking for. Do you know when videos 2 & 3 will be available?

    Reply

  • I pull things from our Financial Database in queries into PivotTables. I am comparing if someone has given to multiple mailings and also to find the totals 2 weeks after a mailing begins to see where we are and if we are in range with previous mailings.

    Reply

  • Clearly laid out Jon, thank you. I use VLOOKUP to return commission %’age based on name or underlying company or product.

    Reply

  • Really very nice video
    I used this formula some time but always i am confused but after seen this video i have cleared all my doubt about Vlookup.

    Reply

  • Thank you for the great videos, the clarity of instructions and the useful tips. I use vlookup as a substitute of nested IFs to assign categories to list items or to connect organization codes to their matching department names, great time saver and reliable method especially when combined with Excel tables to store reference data. I am always learning something new, thanks a lot!

    Reply

  • Awesome video Jon! Love all of your video, clear and easy to understand. Another function that interest me would be the sumproduct functions. Wish you would make some of those!

    Reply

  • Thank you for the videos Jon! I am using Vlookup to compare a bill of materials to a part database to determine whether the part already exists in the database, or if the part information needs to be added to the database.

    Reply

  • Another educative Video John. Iam going to use Vlookup to search for pdoduct Prices in our product listings database. Any Idea as to when i will have andy back with Video #2 on Vlookups?

    Reply

    • Thanks Allan! I space the videos out about 2 days apart to give everyone time to watch them and practice.

      Reply

  • Greetings, I will be using V-Lookup at work. I work for a manufacturing company in the accounting department and we deal with large amounts of data and sometimes need to pull a specific invoice from our statements that are exported unto excel, so with lookup I can easily pull that Invoice with the V-lookup formula.

    Your cheat sheet will be very helpful!!!!!!!

    Thank You,

    Kimberly Maldonado

    Reply

  • Thanks Jon, your video is great! After watching it, I realized that VLOOKUP is not what I need. I think that I will need INDEX & MATCH. The spreadsheet that I am revising needs a formula where I can type in a name & the function will search in 12 other sheets, in 2 columns & returning the date or dates that the name was entered on. Is that possible?

    Reply

    • Hi Margie,
      Yes, that is possible. It requires a pretty complex formula though. Here is an article that explains it in detail. I hope that helps. Thanks again!

      Reply

  • Thank you so much for providing such great training! I am currently using the vlookup at my job, creating order forms for our customers, my son helped me set it up, but now I actually understand how to do it myself, making many more jobs much easier.

    I am very much looking forward to the next video, thanks again!

    Reply

    • Hi Margaret, That is awesome! I’m happy to hear you understand it and are learning Excel. Thanks again for the nice feedback. 🙂

      Reply

  • HI JON,

    GREAT VIDEO AND THIS IS REALLY HELPING ME BIG TIME WITH MY NEW JOB AS A COST ACCOUNTANT. HOPEFULLY I WILL ALWAYS KEEP IN TOUCH FOR NEW VIDEOS E.G. INDEX MATCH.

    Reply

    • Thanks Samuel! And congrats on the new job! Awesome! 🙂 I will keep you updated on new posts in the future.

      Reply

  • Such helpful videos!! I will be using the lookup formulas in my new position as a finance specialist… been working retail and finally landed a position in finance and needed to refresh my memory, as it has been 11 years since I used Excel in any involved application. Forgot how awesome Excel can be when you possess the know-how. Thanks so very much Jon!!

    Reply

    • Thanks Mike! And congrats on the new job. That is awesome! You are right, Excel provides endless opportunity for learning and problem solving. Have a nice weekend! 🙂

      Reply

  • FIND CUSTOMERS LIKELY TO NEED OUR SERVICES IN THE NEAR FUTURE BECAUSE THEY ARE CLOSE TO PAYING OFF THEIR CURRENT LOAN(S)

    Reply

  • thank you so much for your time and kindness. What U do is just great. I am addicted to MS Excel already 🙂

    Reply

  • Hi Jon.

    I am using vlookup to extract prices from a pricing sheet in the same workbook and generate a quote.

    The formula I am using is:

    =VLOOKUP(B22,Security!$A$1:$L$13,6,FALSE)

    when I open my workbook, it goes on a trip around the world before it settles down and allows me to do any input.

    Any change I do, the same thing happens

    Driving me crazy 🙂

    Any recommendations

    Reply

  • I use it to convert trail balance details from a client and reorganize into essentially a table to be used in another application.

    Reply

  • I plan to use Vlookup for streamlining schedules as a quick look up form. I have a better understanding of the process and plan to make better use of my newly gained knowledge. Thanks Jon.

    Reply

  • WOW! How long I waited for these days of send away my doubt.
    Thank you Great you saved me.
    10000000000000000000000 Amazing explanation.

    Reply

  • I know the very basics of excel. Your video tutorials are helping me to expand my knowledge which is taught in away I am able to understand. Many thanks Jon

    Reply

    • Awesome! Thanks for letting me know Donna. I’m happy to hear you are learning more about Excel. Have a nice day! 🙂

      Reply