How a vlookup could be used to find employee information

Assignment Help Computer Engineering

Reference no: EM133361807

Question: 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 "key" piece 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.

Reference no: EM133361807

Questions Cloud

Provide a brief summary of your progress to date : Update all project documentation, showing that you have applied the instructor or peer review feedback from your previous capstone milestone assignments

How it is currently deployed in the company : ??An explanation of how IT is currently deployed in the company and how it meets its aims and needs ??The characteristics of different cloud technologies

Have any moral rights been violated : Evaluate the ethical implications and impact of the events of selected business situations using predominant ethical theories and concepts

Write the regular expression that matches any string : Write the regular expression that matches any string that begins with a digit, ends with a digit, and has AT MOST only one digit in the middle of the string.

How a vlookup could be used to find employee information : 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

Describe how you tested your code : Describe how you tested your code. Try the following experiments. Write several sentences about what you found or learned working on each, and on any other

Create a query to display sales for more than $50 of trumle : Create a query to display sales for more than $50 Of Trumle flavored popcorn from the SalesArchive table a. Include the following fields in this order

Described optimization could make loads and stores : Suppose that a given optimization results in an OVERALL speedup of 1.5 over the original design. If the optimization speeds up loads and stores by a factor

Resources on proper health record documentation : Locate three websites that provide information and resources on proper health record documentation.

User Account

All Pages