The VLOOKUP (Vertical Lookup) function in MS Excel searches for a value in the leftmost column of a table and returns a value in the same row from a specified column.
For example
This is one of the most commonly used functions for finding and retrieving data in structured tables.
