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:
- Put all the data in one spread sheet, but different tabs.
- Clean up the data, make sure your lookup value is a number. It could be a string if it wasn't actually a number.
- 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!
