Excel question: VLOOKUP

Answer in a few sentences

Directions: The VLOOKUP function is used to find Information from a table. It needs a search value which matches one of the entries in the table, and based on this match, you can find relevant information about that value. For instance, if you have a product code, you can search for its match in a product details table and find the detailed product description, Its price, or its inventory level. Imaginethat you maintain an employee database. What would be the primary "keypiece of information in the database (that is, how would you identify each employee)? What employee data would exist in the table for each employee? Explain how a VLOOKUP could be used to find employee information