VLOOKUP is one of the most widely used functions in Excel. It allows you to vertically lookup a value and return an exact or close match from a table / array of data. It looks at a value in one column, and finds its corresponding value on the same row in another column.
View this 4 short video tutorials by Microsoft about VLOOKUP:
Although we do not agree with those who claim to be Excel gurus once they master this function still it is one of the function any Excel user should know how to use it. Later in the course we will discuss the alternatives to this function as there is a more dynamic way to achieve better results.