What does the VLOOKUP function in Excel do?$?$

(1$(1$ Point)$)$

It performs mathematical operations on a range of cells

It checks if a condition is true and returns one value if true and another value if false

It searches for a value in the leftmost column of a table and returns a corresponding value from a different column

It calculates the average of a range of cells