VLOOKUP function

If you do not know the Excel VLOOKUP function yet, get excited! It is about to change your life.

The formula is written as =VLOOKUP(criteria, matrix, column number, 0)

What the VLOOKUP function does is that it looks for a criteria across to the right in a data table in the column number that includes the desired data.

The last thing we need to do is to tell Excel if we look for an exakt match “0” or an approximate match “1”.