I have this problem in excel accounting and dont know how to incorporate the vlookup fuction in it. This is my instructions followed by the information, any help with some step by step directions would be great, i have a feeling its something easy and im just missing it. Thanks.

Complete M29, which is located in the back of your textbook in the Back Matter section, under the Model-Building Problems. You will need to create your own Excel template. In addition to the requirements in the textbook, you need to use the Vlookup function to populate the name of the department within your problem.

M29 EMPLOYEE PIVOT TABLE

The following data come from an employee data for Husker Industries. You have been asked to create a worksheet file of this information (file name EMPLOYEE). See Appendix C in Excel Quick for a discussion of pivot tables.

Employee No.

Name

Department

Gender

Salary

Bonus

1

Tammy

Accounting

F

$40,000

$4,000

2

Adriane

Purchasing

F

$52,000

$2,500

3

Logan

Marketing

M

$80,000

$3,200

4

Star

Payroll

F

$37,000

$1,000

5

Jeremy

Accounting

M

$92,000

$4,400

6

Matthew

Purchasing

M

$44,000

$1,000

7

Joshua

Marketing

M

$75,000

$1,000

8

Emily

Finance

F

$41,000

$1,000

9

Shannon

Accounting

F

$68,000

$5,200

10

Cody

Marketing

M

$30,000

$1,000

Review the Model-Building Problem Checklist on page 154 to ensure that your worksheet is complete. Print the worksheet when done. No check figure provided.

Test your model (and your pivot table skills) as follows:

Ms. Husker would like three more reports.

1. Printout of a table showing total salaries by gender. 2. Printout of a table showing total salaries by gender and by department. 3. Printout of a table showing employee name and bonus by gender for the Accounting department.