In Excel, which of the following statements about the VLOOKUP function is correct?

a$.$

VLOOKUP can be used to search for values in multiple columns simultaneously.

b$.$

VLOOKUP can only search for exact matches and cannot perform approximate matching.

c$.$

VLOOKUP is used to search for a value in the first column of a range and return a corresponding value from a specified column.

d$.$

VLOOKUP can only search for values in the same worksheet and cannot retrieve data from other sheets or workbooks.

e$.$

VLOOKUP requires the data to be sorted in descending order for accurate results.