5. In cell I10, add a lookup function nested in an IF function that will determine whether or not certification was achieved. If the score is greater than zero, the function will return the value in the second column of the certification table on the DataInputs worksheetcell range F9:G11. If the score is not greater than zero, the cell should remain blank. Copy the formula to I91.

1 Training Data PID-Entry Date Class Name Score Class_Type Reimbursement Result Points Weapons Total Classes otal Classes PID-Entry Class_Name Time Cost Score Class_Type Reimbursement ResultPoints VLOOKUP 10 P1059 11 P1059 12 P1059 13 P1059 14 P1330 15 P1330 16 P1330 17 P1330 18 P1330 19 P3381 20 P3381 21 P3381 22 P3381 23 P4098 24 P4098 25 P4098 26 P4098 27 P4098 28 P4098 29 P4098 30 P4611 31 P4611 32 P4611 33 P4611 34 P4611 35 P4611 36 P4611 37 P4916 3/23/18 Weapons 30 $ 155.0078Class 60$ 190.0086 Class 60 90.00 97 Class 30 170.00 55 Class 30 $ 110.0090 Class 30 $ 110.0098 Class 30 150.00 82 Class 4/5/18 FirstAid 4/7/18 Investigation 5/27/18 Negotiation 2/12/18 Investigation 2/14/18 Negotiation 3/15/18 Investigation 3/28/18 Exercise Physical 4/8/18 Exercise 2/10/18 Weightlifting 3/7/18 Negotiation 60 S Physical 60 190.00 82 Class 30 170.0077 Class 30 $ 150.0087 Class 60 $ 150.00 80 Class 5/30/18 FirstAid 6/26/18 FirstAid 2/15/18 Weapons 3/3/18 Exercise 4/22/18 FirstAid 4/25/18 Combat Physical 60 170.00 90 Class 30 115.0079 Physical 5/22/18 Weightlifting Physical 6/4/18 Driving 6/29/18 Combat 30 $ 135.00 72 Class 30 $ 90.0077 Physical 30 $ 185.0066 Class 60 $ 220.0078 Physical 30 200.00 83 Class 60 190.00 97 Class 3/3/18 Investigation 3/20/18 Combat 3/25/18 FirstAid 3/30/18 FirstAid 5/5/18 Weightlifting 30 $ 5/9/18 Negotiation 30 $ 155.00 84 Class 5/27/18 Investigation 30 $ 240.0069 Class 30 $ 185.00 65 Physical 1/19/18 Combat Certification Score Result 0 Retake 701 Passed 85 Honors Gold 4 or more classes Average score greater than 90 lowest score 85 or better