Vlook up

This is a function on excel that will line up two different excel files next to each other that have similar data in order to match up its data or find relevant data by using each other. An example of this could be trying to find user names accordingly to ID numbers that are displayed on a different excel table. 

Vlookup equation:

=VLOOKUP(What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an Approximate or Exact match – indicated as 1/TRUE, or 0/FALSE).

On your excel file,click on the cell that you will want to fill with the correct data from the alternative excel file. Once it is selected, start type in "=Vlookup" each time a function gets typed in you will be able to see a drop down option that will allow you to select the correct function without having to type it up, click Tab to auto select it.

Now that the function has been activated on that cell, you will then want to select the a cell on the column that you want the original excel file to be looking against. The selected sell will then get registered into the Vlookup equation found at the top of the file while being edited. Make sure to add a comma after every value you have entered in order to divide each value from each other as well allowing you to move on to adding in the new value.

Once the column has been added in from what you want to look up, you will then need to highlight the data on the other able that you will want to compare the original table with to be able to match up the data. The best and most secure way of doing this is by highlighting the whole table so that you don't miss out any data by mistake. 

The next bit of information that you will need to include in the equation is the number of the column that you want to to look up against. An example of this is if you highlighted a whole table but you are only looking for the data in the second column you will the have to enter the value "2" into the equation.  The column number is based on what you have highlighted, it will be the second highlighted column in this case. 

The last step will be the either a true or false selection. This step of the equation allows you to select weather how accurate you want your results to be. Selecting the true option will give you approximate results as it will only search for the the nearest matching results. The false option looks at each letter and makes sure that it is picked the exact values to match the data.