VLOOKUP function

VLOOKUP stands for Vertical LOOK-UP.
VLOOKUP function is one of the most fundamental and effective Excel functions, its advantages really depend on how cleverly you can use it.
How it Works-
According to how many columns are chosen for the result, it finds the entry associated with the row that contains the indicated cell in the target column.