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!
thank you for this very informative video. I will basically need it to look up info as described in the video
Looking up the price of material from a specific supplier
Awesome one, thank u so much
I m using vlookup to find employee details.
Thank you for your video.
I am using vlookups for forecasting & sales data.
Hello! I would like to try VLOOKUP in my reconciliation report and if it will work – that will save tons of time during my work day (especially when I’ll manage to turn it into VBA macro)))
Thank you Jon for a great video!
Great video Jon – easy to understand. Thank you.
I need to look up dozens of things, from fee schedules to claim data, in extremely large spreadsheets. I couldn’t do it without vlookup…thanks!
I used VLookUp for my school certificate project. At first, it was very difficult but with my brother help and looking for lessons from other websites it became easy.
Thank You for these lessons.
Great lesson. It often surprises me as long time excel user that simple lessons well told can gain you back so much more time as you break off old habits and replace with this better understanding. Bravo, look forward to the next one. Ive already taken note of few items on youtube site as well…
A very simple to understand and pwerful presentation. Thank you very much for this great informative video. Look forward to other 2 videos soon. thanks again.
I used it for looking up exchange rates.
Tbd in my new role (hopefully)
Thank you.i want to learn how can I create dashboard.
Thank you…
I am using vlookup for my office work.
I will utilize VLOOKUP to find Order Numbers.
Financial modelling
I have had problems getting the vlookup to work, it always blew up on me. I now understand what I am doing.
Thanks, excellent clear teaching. Looking up HR data
More advanced Accounting reports.
Excellent video-used for sales and accounts data
Love yourvideo. Can’t wait for #2. I need to learn how to trouble shoot errors.
Thanks
Gloria
Looking up the price of items in stock
I need to use for looking up stock prices
Really good content, so thankful.
Great video – need to expand my excel skills for job search process. Thank you !
Hi Jon,
I used Vlookup in finding the size of conductor and conduit after calculating the load (ampere) of an electric circuit.
The video helps a lot in understanding the function.
Thank you,
Pepito
I have a workbook that I use for collecting money for a prize at the end of the season.The sheets of this workbook are date based. I can create a table in the master(sheet 1) that will determine the dates of all the weekly sessions. What I need is to rename the sheet dates every year. So basically there will be thirty five sheets for the complete year. So sheet two will be the first week of bowling and with this process I’ll be able to find the correct value for that week and rename that sheet to the first week. Basically the table will be a 2 X 35 table
Mostly just expanding my knowledge of excel as I use it a lot in my daily work and am excited to get it working more efficiently for me in the future 🙂
I work on financial reporting
Great intro to VLOOKUP!
I’m looking for a simple way to compare two check ledgers or stated another way, two tables of check numbers with corresponding amounts. One ledger/table (checks that have cleared the bank) will be a subset of the other (checks written). The task is to identify checks that have not cleared the bank as well as to flag ledger-entry errors made when recording checks written.
Thanks for the video, you have explained it very well. I use vlookup to find a certain value in other spread sheets relating to a reference number.
Hi, Yes I use vlookup to extract data from a sql data which has been loaded into another worksheet. Whilst I am familiar with the procedure I have learnt some very useful tips which will help me no end e.g. use of the F4 key to change absolute/relative writing within the formula. Thank you. Looking forward to watching the index/match video which is something I have never used or quite understood.
I am constructing a cut list calculator for cabinet doors. I am sure I will be looking up values for different part dimensions to determine the final part sizes. I also am developing a cost list that is based on style and specie of wood.
I have tried to understand v-lookup for a Long time and I just cannot grasp the basic understanding. Your explanation is so clear and simple. I understand perfectly. It will definitely save me lots of time in my daily analysis report.
Fantastic! Great help! Thank you so much!
Vlookup is useful for financial analysis for performing an audit and to find exception.
i am going to use vlookup for data analytics for internal control purposes.
Great video! So easy to understand. However, the row-column indicator once you select the table array, does not appear in my screen. Is it because I am using a Mac or have a different Excel version to yours? Will certainly keep learning from your videos! Thank you
Hi john,
Are you putting this video in YouTube.
Thanks
This is a good question. Below is what I’m using for VLookup now.
I reconcile my employees expenses (General Ledger) account. The reconciliation sheet lists (key/unique number) employees numbers so, at the end of each month I download from our Crystal payroll system for each employees paid expenses (source; payroll) and I also download the employees time sheets approved and submitted into our E-time system. Both systems do not interface with our GL software so I have to do Journal entry into the GL for both (Crystal and E-time).
Now, my reconciliation sheet has five columns (emplyee#, name, expenses/costs as debit, and payroll and Accounts Payable as credit).
So, the lookup value is employee# (common to all three data (Expense, payroll and AP). But it is massive as we have 1,000s of employees and growing each month.
This is how I use.
Thank you, Jon,
This video is very useful to me.
Very good explanation. I’ll use it in my data analysis
Thanks for the video. You provided the logic of this very important excel function. I do not know how can I reciprocate you. But God will reward you in Heaven.
You inspire me and may your grace and kindness reach millions of people in this universe.
Thank you for the help. I will use it in my work
Thank you for the help. I will use it in my work
Thanks John for another excellent, clear to understand, short and sweet Video that you always do so well. As a project planner I’m using a wide range of Excel functions in producing reports, curves etc. As for VLOOKUP, one of my favorites used on a daily basis I’m sure I will find from these videos that “extra” thing, even if it is only your use of shortcuts to do certain tasks. Looking forward to the balance of this series.
I will use this video to manage data.
nobody would have explained it better…thanx a million!!
Very well presented. Please keep up this good work.
Thanks for this, especially the explanation of why we need to make the reference absolute and how to do that.