The Lookup Formulas Training Series Part 1:
The 5 Essentials to Getting Started with VLOOKUP
Download the file used in this video:
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!
Our company uses Microsoft GP which has many Excel data download features. I have been using VLOOKUP for many specific data searches within these downloads but learned a couple valuable tips from this video.
Is the first i try and i love it!!!
Just curious to know something about vlookups. It was great and good to know and understand.
Thank you.
I use vlookup to search for certain data in a huge project am currently working on. Great video.
Thank you Monther! 🙂
I didn’t understand what I can with VLOOKUP.For what we have to use that funkcion ? Could you please explain. Thank you
i am learning how to use VLookup to get a value. This video is very helpful.
Thanks
Tyring to see if this useful tool is what I need to manipulate the data in my spreadsheet. Excellent video. Very helpful.
I love the Starbucks example – very helpful!
Thank you jon. Really it’s very important function.
Thanks Mahmoud!
This is fantastic intro course. However, it’d be better if the video included the functions that can be used in Mac as well. Millennials in these days are big fans of Mac, and they want to use it on the mac. Other than the one platform-oriented function, I found this website very useful. I hope my comment helps!
Great video !!! Regards from Italy
Absolutely Doodle Dandy! Keep Teaching!
simply explained, good video
I sometimes use vlookup to access standard values from a table to then be used to calculate or print the result be it number or text
Great video Jon, thanks. we deal with a lot of surveys data and I’m hoping that this will help streamline the process I already have.
I am also interested in pivot tables and the use of % within the pivot table; based on individual totals as well as grand totals. ie a teacher has 16 sessions to observe so I need a % completed per teacher but also a grand total % for all teachers if you understand what I mean, if you have a video that covers this already please could you point me in the right direction if not any help would be greatly appreciated.
Thanks again for all your videos, great work, I am really enjoying learning new (to me) features of the application
Thank you, Sharon! I do have a video that explains % of total in pivot tables. It’s video #2 in a 3-part series on pivot tables & dashboards. I also have a video on analyzing survey data. I hope that helps. 🙂
I use it extensively to provide a single place to enter data in one place and use it in multiple places
Sir,
I have a workbook with many sheets linked with long formulae.
I face problems with Ref# errors when my staff cut & paste or move the original cell contents.
I don’t want the cut, copy & paste to be disabled,
but the cell reference must not be changed when cut, copy & paste or move the original cells.
Please help…!
very smart
Hi Jon, great video!
Simplified explanation and now I understand how to use the vlookup function. I want to use this function for my database clean-ups task at the work and knowing how to use the vlookup function will definitely save me a lot of time. Once again thanks for this, it’s extremely helpful.
Thank you so much Herman! I really appreciate the nice feedback. 🙂
It would be interesting to be able to add a second search aspect. For instance, when your family visits Starbucks they don’t all want the same size drink. If you can add more search aspects the dynamism of the vlookup function could be quite powerful.
Hi John,
Great suggestion! We can add multiple criteria to the lookup formulas. I explain more about that in the Ultimate Lookup Formulas course.
In the case of multiple family members, we can add additional cells with vlookup formulas to calculate each drink price.
Thanks!
I use Vlookup daily to combine data from separate reports. I feel very comfortable with it but know there is always more to learn. I look forward to Vids 2 & 3 and also to joining the class when you open it again.
Hi Jon,
I am using this video for training purpose.
Hey its really nice video. Looking forward for upcoming videos. I really want to learn excel and its of great help !!!!!!!!
Hi Jon,
very useful video! Good explanation, great example, and valuable tipps. Thank you.
I use vlookup up for several reports run. One of them being commission. I have been using vlookup for quite sometime but always like to refresh my memory.
I found the way you used examples very enlightening. THank you
I want to use it to analyze results of students and make decisions
The video was very helpful Jon.
My project is to use VLOOKUP to create a form from a data set.
e.g. sheet1 contains my data (i.e. SName FName DOB Sex Address etc as column headers)
on sheet2 create a form such that entering the SName value in a row will return all the details in the row on the form.
Thanks a lot sir, hope to have another tutorial. Godbless always 🙂
Production planning
Thanks Jon! Wonderful explanation, Learning Excel is so much fun and easy with your explanations! thanks again..
I will use the information in the video to analyze large amounts of data for work. The video was very informative. This is my first time using Vlookup, and it is wonderful tool to have. Thank you.
Gwendolyn – June 1, 2017
I will use the information in the video to analyze large amounts of data for work.
very helpful …thanks……..
To find duplicate data elements in a vertical list, such as duplicate names or social security numbers.
I’m already using vlookup to analyze large amounts of data for work, but your video clearly explains the meaning of it! I’m really interested in your upcoming videos! Thank you
Great explanation with regards to the difference between the true and false. Never knew sorting was critical in getting it to work! Love this session!
Hi Jon,
what a wonderful video tutorial accompanied with Simplified explanation, I can now stand high and be confident that i understand how to use the basic vlookup function. I will use this function for my database clean-ups task at the work especially in project beneficiaries allowances,the vlookup function will definitely save me a lot of time. thanks a lot for this wonderful video and explanation.
If VLookup uses the first row it finds with the Lookup Value in it, what happens to the other rows that have the same value (e.g. Caffe Latte in your example)? Are they overlooked?
I use VLOOKUP in searching for huge amount of part numbers, makes it a lot easier!
Hi, thanks for the tutorial. I will try to find smaller sets of identification numbers inside larger sets
Interesting and helpful video..i want to learn more..thanks Jon!
I am not sure yet but found the video very informative
to find data on a daily basis in a very big spreadsheet at work
To take over masses of spreadsheets setup by someone else and understand how they work!!!! Please could you also produce a sheet of shortcut keys as used in the video (F4 etc)
Hi Jon,
I generally will used the VLookup for Roster data with Multiple spreadsheet relation.
Thank you
I use vlookup to find a product and return quantity available and quantity sold from the data.
Hi Jon:
This is a wonderful explanation and very clear way to understand. I just started working with too much data and it takes time. I noticed that others used VLOOKUP then I decided to learn.
Thanks for sharing,
To avoid nested IF conditions
Our design team is transitioning to a set of workbooks that use a lot of custom VB formulas. This was a great introduction to one of Excel’s built-in formulas (VLOOKUP), but it’s also a good introduction to how arguments are passed into other formulas, including routines that the user can create themselves in Visual Basic. I plan on sharing this with our team to help get them trained up and more familiar with Excel and VB. Thank you!
Great videos, really helpful.