Explanation

The VLOOKUP function in Excel searches for a specified value in the first column of a table and returns a value from another column in the same row.

The VLOOKUP or Vertical Lookup function is used when data is listed in columns.