What is the function of the VLOOKUP function in MS Excel?

A. To find the average of a range of cells.

B. to add up a range of cells.

C. to perform a horizontal lookup and return a value based on a specified criteria.

D. To perform a vertical lookup and return a value based on a specified criteria.