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!
Small business inventories.
Great video by an excellent instructor. I’m glad to be part of the Excel Campus community
I’m rolling my own stock tracking workbook. I’m currently using only VLOOKUP, but I think I’ll benefit by integrating INDEX & MATCH functionality. In the meantime, here’s the evolution of my VLOOKUP:
Original version:
=VLOOKUP(A6,tblTx,4,FALSE)
Improved—this matches for the current row’s value for BuyID on equivalent column headers
=VLOOKUP([@BuyID],tblTx,MATCH(tblAnalysis[[#Headers],[Status]],tblTx[#Headers],0),FALSE)
Better yet! This one matches for the current row’s value for SellID on disparate column headers, e.g., TblTx.Date to tblAnalysis.SellDate
=VLOOKUP([@SellID],tblTx,MATCH(RIGHT(tblAnalysis[[#Headers],[SellDate]],4),tblTx[#Headers],0),FALSE)
to help me cleanse my data as a Tableau Developer
Creating order forms.
Projects at Cerner
Hello, Unfortunately – I tried multiple time to watch the video and it just
stops at .24 and wont continue. I was so looking forward to viewing it.
Using the vlookup to reference an existing req table for position titles, unit #’s, as well as if specific position titles required training ( seperate req table)
Excellent video! I’m adding to and brushing up on my excel skills to prepare for an upcoming position. Learning and putting it into practice when you have the pressure of deadlines and learning a new industry is a bit challenging.
Adding price values on one spreadsheet, to a build list on another spreadsheet to calculate a product cost price.
I am starting a new role in a new business. Creating reports and analysing trends in data will be part of my tasks. I feel very excited about it since I’ve been watching your videos and materials (along with other training tutorials), working on the excercices you shared with us and learning a lot about excel. Excel is such an amazing and powerful tool, and I am super liking it!
Thanks for sharing your knowledge, I very much appreciate it. You are an excellent teacher!
Thank you! I want to brush up on my Excel skills as I’m starting to looking for a job again after having been on a ‘gap’ year for the past 18 months.
I already frequently use VLOOKUP and HLOOKUP, but infrequently use INDEX/MATCH. When I do, I often have to review instructions to remind me how to structure the formula. So I am hoping your upcoming video will help me better understand and remember the instructions.
Video stuck at 53 seconds
Lookup Formulas Training Series “Video 1” cuts out after about 26 seconds of viewing.
The browser I’m using is FireFox Quantum 68.0.2 (64-bit)
Lookup Formulas Training Series “Video 1” runs all the way through to the end.
The problem seems to be in the FireFox browser Version 76.0.3809.132 (Official Build) (64-bit) which quits working and seem to go to the end of the Video
Correction to my 4:00 pm comment I left:
Lookup Formulas Training Series “Video 1” runs all the way through to the end when I am using the “Google Chrome” browser Version 76.0.3809.132 (Official Build) (64-bit)
The problem seems to be in the FireFox browser Version 68.0.2 (64-bit) which quits working and seem to go to the end of the Video after about 26 seconds of watching the video.
Portfolio project budgeting and budget tracking.
I will useVlook up to determine which patients are 30 days or more delinquent in their payments
Find duplicate rows.
peace upon you
I have an excel file I want to call an image without hyperlink
I am using Vlookup to define deployment status catagories
I will be using VLookup for Department Surveys.
I’m going to use it to create a report.
I will be using to report timely filing denials for payer BCBS in the Month of February 2020.
I would like to use VLOOKUP to identify clients within a spreadsheet that have AR Days greater than 90 each month
Not sure at this time. I will be using this to assist clinic managers with data.
I am using vLookup to identify name of shop owner, location, and their contact numbers.
The monthly data mostly > 800 names
I’m trying to see if this will help me determine (along with a MIN or some other function) the earliest date for each person in a transaction list.
Excellent Video! I like your simple definition of VLOOPUP:
=VLOOKUP(what, where, column num of TABLE not WORKSHEET, closest match)
Track my production plan at work
Data cleansing
Financial results in an overview
I am really excited to be learning this excel tools from you. I am going to use it to sort out data for my financial reporting. Thank you so much
The link to the video doesn’t seem to work?
I’m not able to view the videos. The icons for each are there, but there’s nothing to click on to go to the videos.
I often want to look up deltas between audits generated at the start of the project and then compare to the most current build so I can see what has changed between the initial phase and current state.
I want to look up deltas between audits generated at the start of the project and then compare to the most current build so I can see what has changed between the initial phase and current state.