Vlookup - Basic Spreadsheet Training

So here is a video of me doing a basic vlookup in microsoft excel.  

https://drive.google.com/file/d/1y1uK89iylU-eyAl9t2uzz2aNhyDd83C-/view?usp=sharing

A quick rundown of the steps I do in this example:

  1. Put all the data in one spread sheet, but different tabs.
  2. Clean up the data, make sure your lookup value is a number. It could be a string if it wasn't actually a number.
  3. Select the cell you want the function to be in and then click the "Fx" in excel to find the Vlookup function.

 4. Know your 4 pieces of information you need for the function.  IE: Lookup Value, Table Array, Column Index # and Range Lookup .


 a. Lookup Value - This is the matching piece of data that exist on both sheets.
 b. Table Array - This is the table of data that you are going to be pulling the data   from.  The matching lookup value needs to be the first column in the table   array.
 c. Column Index number -  Represents what column in your table you want to   pull the data from.
 d.  Range Lookup - Easy to remember, because it's always "False."

If you have read this far and would like any other quick reference data like this please let Trevor know.

Peace!