In the video below I provide a tutorial on how to use the Excel Lookup. I also provide hints on common mistakes/problems using the function.
FunctionLooks for a value in the leftmost column of a table and then returns a value in the same row from a column you specify. By default the table must be sorted in ascending order.
VLOOKUP(Lookup value, table array, col_index_ num. exact match?)
1. The table containing the data you are looking to should have the leftmost column (you will be using) sorted in ascending order – In the video that is Column A on the sheet on the right.