In Microsoft Excel, what is the primary purpose of the VLOOKUP function?

a$.$

VLOOKUP is designed to search for a specific value in a table and return a corresponding value from a specified column.

b$.$

VLOOKUP allows users to create and customize pivot tables for data analysis.

c$.$

VLOOKUP is a tool for spell$-$checking and proofreading Excel documents.

d$.$

VLOOKUP is a feature for encrypting sensitive data in Excel spreadsheets.

e$.$

VLOOKUP is designed to search for specific values in a table and return the average of these values