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.xlsx (432.7 KB)

VLOOKUP Essentials Guide - Excel Campus.pdf (405.5 KB)

Lookup Formulas Training Series

Video 1

Intro to VLOOKUP:
The 5 Must Know Essentials

 

What Are You Going To Use VLOOKUP For?

Please leave a comment below with your answer, and any questions.  Thanks!​

  • 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)

  • 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.

  • 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.

  • I would like to use VLOOKUP to identify clients within a spreadsheet that have AR Days greater than 90 each month

  • 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.

  • >