What does the VLOOKUP function in Excel do?

Sorts a range of cells in ascending or descending order

Searches for a value in one column of a table and returns a corresponding value from a specified column

Performs mathematical calculations on a range of cells

Converts text to uppercase or lowercase

Searches for a value in one column of a table and returns a corresponding value from a specified column