- To create a chart
- To sort data
- To find a value in a table based on a matching value in the first column
- None
Read More About This Mcq.
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.