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!
very helpful indeed. Looking forward to the match&index video.
HI Jon
Great video as always and simple explanation, thank you. With regards to the ‘sorting myth’, I have created numerous VLookUps and have always sorted the LookUp data in an ascending order because that’s what it instructs you to do in the dialog box itself when constructing the formula. Why would it state to do so if in fact it does the same thing when it’s not sorted? ARe you able to clarify?
Whenever I have shown colleagues how to use this feature I have always stressed the sorting element.
Thanks again.
Louise
Hi Louise,
That sorting myth is kind of an old tip/technique from early versions of Excel. As computers got faster, we no longer need to sort the data if we are performing an exact match. In the majority of cases, the vlookup will perform very quickly with unsorted data. If you are copying the formula down thousands of rows, then the calculation will likely slow down. In this case you might want to try sorting the data and/or using a different technique for creating a relationship between data sets. I hope that helps.
Hi Jon
When will the other two videos be available?
Thanks.
Louise
Very helpful indeed.
it is very helpful, and the way of expressing is very simple and interesting.
I am hopefully going to work for a reputable guitar company. One of my responsabilities will be sorting data.
I am a trainer in a large legal firm, and I will use this course to brush up on my Excel skills.
Awesome! Thanks David!
Very Helpful, Thanks!
Very useful
The training has been my eyes opener,thank you very much Jon! are you coming up with other excel functions?
Thank you Balozi! Yes, we will cover other functions in the 3rd video including INDEX & MATCH.
Easily explained.
Thank you
I use vlookup to get city, state and region from a list of zipcodes.
Great video and explanation on how to use “Vlookup” in the simplest form. Thank you again
Extremely helpful video
i want to use Vlookups for analyzing large amounts of financial data
Thanks for the Vlookup video
Use vlookup for making monthly reports
comparing data between 2 reports
THANK YOU VERY MUCH !! Its very helpful . Its one of the best excel videos I have ever seen. I normally learn from online. Your one is very simple and a very clear way to understand. I work with huge Data . I am looking forward for the future videos. Again thanks for your help.
Thank you for sharing. Its very valuable to quickly find the values you are looking to extract.
WOW!, I learned a few new things about Vlookup. I use it all the time for reports that I have to combine to get all the information needed. For Example, one report returns the employee’s position but not the funding. So I use Vlookup to combine the information.
Hi John, brilliant video and very well explained. I am a transport manager in a large public service transport company. We use Vlookup to match the fleet numbers of a fleet of public service vehicles with their technical number, used for satellite navigation and also the fleet numbers to match the vehicle types based on the type of work performed by each vehicle.
Regards
Pat
Fantastic..learned a lot on the first video. Needs to combine information from different excel workbooks.
Hi Jon
I am using your videos for training myself in Excel. I love Excel too.
I needed it for searching specific figures across multiple sheets of a workgroup related to different IT projects details in excel. Very informative and eloquently explained each n every step along with the concept. Very thankful to you.
I use vlookup all the time but as always, the devil is in the details – the keyboard shortcuts and the hint on determining the column to return will certainly speed things up for me! As always, well explained and easy to follow. Thank you!
Thank you. I thought i knew the basics of excel but am discovering I knew nothing! Keep them coming!
I would like to use Vlookup in a macro. I want excel to look up today’s date in column A and return the message in column B. I want this to happen automatically when the user opens the workbook. I also want the vlookup formula to ignore the year.
Its very valuable
THANKS VERY MUCH I LEARN MORE TODAY ABOUT VLOOKUP IN EXCEL AN I WANT TO NO MORE ABOUT PIVOT TABLE, AND DATA COLLECTION SPREAD SHEET
THIS WAS A VERY GOOD LESSON.
Use to find sales data by employee
Shortcut keys very helpful wish they were also included on the PDF info
Great tutorial Jon
Thank you
I will be using vlookup to identify employee name with employee id number
Jon,
it is very useful and appreciated effort
thanks,
Hi Jon, I plan to import Clients with their address into an invoice form from a dropdown list. Thank you for your explanations, it is easy to follow. I look forward to learn from the next video on error messages.
very helpful, thanks
Very helpful, I am waiting the next video. Thanks
I use for various reporting tasks
Very helpful, and excited about the next steps, Match & Index.
I want to use it for reconciling Monthly Creditors Statements to the creditors control account in the General ledger, and Accounts Payable reconciliation at the end of the Month.
Hi John,
thanks for great lesson.
I want to ask you sth about IF.
If time is less then 06:00 hrs out put “Need”otherwise “W/H” how to use if function only for hh:mm?
Regards,
Thank you Meytithveasna. Here is an article on the date system in Excel. 6:00 is a fraction of a day (6/24). So the formula would be:
Here is an article on the IF Function. I hope that helps.
Im looking to learn what there used for and how i can use them efficiently on my source data
Da forma que explicou é bastante interessante em relação que vimos no dia dia!
Obrigado.
When will the video 2 n 3 arrive ?
Hi Jon,
Thank you for this video, mainly for the importance of archoring the table array.
Jana
Very helpful, Looking forward if Formal and 26 use for if.
Appreciate you usual support
Search through data sheets, I have a number of large spreadsheets that I can use this for.
Hi Jon,
Very good video, I have a large number of spreadsheets to deal with, so I can use this to assist in finding a particular employee or vehicle very easy.
Carson
Dear Jon, Many thanks for sharing this video which is hugely helpful. Nicely explained. I am trying to use it for an invoice template, where the cashier will enter the product ID in the 1st Column then the Product Description and the Selling Price will display in the 2nd and 3rd column respectively.Need to use the Vlookup twice.
thank you jon, being a beginner learned many things very fast after watching your videos…thanks again…
thank you jon, being a beginner learned many things very fast after watching your videos…thanks again…
Thank you Jon, being a beginner in excel learned many things fast and easy after watching your videos… Thanks again… Waiting for second video…
Thank you Jon, being a beginner in excel learned many things fast and easy to understand after watching your videos……thanks again….
To pull in the item quantity for each SKU#