Which of the following statements about the VLOOKUP function in Excel is true?

a$.$

VLOOKUP can only return a value from a column located to the right of the lookup column.

b$.$

VLOOKUP always requires the lookup column to be sorted in ascending order.

c$.$

VLOOKUP is case$-$sensitive when matching the lookup value with the values in the lookup column.

d$.$

VLOOKUP can only search for values in the same column as the lookup value.

e$.$

VLOOKUP can only search for values in a single worksheet and cannot reference other worksheets.