In cell P2, use a VLOOKUP function to determine the annual cost of each employee's medical plan as described below: a) Use structured reference to the medical plan field. b) Use the defined name Medical_Premium (which represents the range S8:T15) as the Table_array parameter value. c) To ensure accuracy, an exact match is required. Hint: The Medical Premium table array provides monthly premium amounts not annual.

fr =IF(M2>20,2,(IF(M2>15,1,0))) M M Years Service N Bonus Week P R S o Vision Plan Cost T O Max 401(k) Company Matc - Medical Cost 2 22.7 21.7 20.7 20.7 20.7 18.7 BRUXELLEXARXER Variables: 401(k) Matching Plans FT PT 2 2 2. 840 360 540 840 360 540 7.00% 4.00% 2 Years service as of: 2014-09-01 1 fr =IF(M2>20,2,(IF(M2>15,1,0))) M M Years Service N Bonus Week P R S o Vision Plan Cost T O Max 401(k) Company Matc - Medical Cost 2 22.7 21.7 20.7 20.7 20.7 18.7 BRUXELLEXARXER Variables: 401(k) Matching Plans FT PT 2 2 2. 840 360 540 840 360 540 7.00% 4.00% 2 Years service as of: 2014-09-01 1