Please complete the attached by using vlook up to populate the costs of each type of benefit.

Sum the rows for total cost per employee.

Create a pivot table by benefit type.

Employee

Benefits type

Dental

Vision

Health

Total

Monthly premiums

Employee A

Employee Only

Employee B

Employee Only

Employee C

Employee $+$ Spouse

Employee D

Family

Employee E

Employee Only

Employee F

Family

Employee G

Employee Only

Employee H

Employee $+$Child

Employee I

Employee $+$ Spouse

Employee J

Employee Only