B G HIJ K L M N O P Q R S D E F 1 Below are employees of ABC law firm. 2 Please calculate their annual bonus. 3 Use a combination of VLOOKUP and MATCH to find their bonus percentage, based on their Title and Rating 4 Multiply their Bonus Percentage by their Base Salary to find their Bonus 5 Calculate Gross Compensation 6 Format the report for readability. Denote Headers. Format numbers, etc. Index 8 Name 9 Addie Joss 10 Al Barlick 11 Al Kaline 12 Al Lpez 13 Al Simmons 14 Al Spalding 15 Alan Trammell 16 Alex Pompez 17 Alexander Cartwright 18 Amos Rusie 19 Andre Dawson 20 Andy Cooper Title Rating Base Bonus Percentage Bonus Total Compensation Trainee Major Deity 130788 Intern Water Walker 83706 Senior Partner Pretty Good 440558 Associate Minor Deity 246547 Junior Associate Not So Good 187732 Intern Rain Maker 62955 Senior Associate Not So Good 294840 Associate Good Enough 206566 Partner Water Walker 397762 Partner Major Deity 370962 Junior Partner Rain Maker 320321 Senior Associate Dead Man Walking 265420 Title 1 Senior Partner 2 Partner 3 Junior Partner 4 Senior Associate 5 Associate 6 Junior Associate 7 Trainee 8 Intern Supreme Deity Major Deity Minor Deity Water Walker Rain Maker Pretty Good Good Enough Not So Good In Trouble Dead Man Walking 56.0% 49.0% 42.0% 35.0% 28.0% 21.0% 14.0% 7.0% 0.0% 0.0% 48.0% 42.0% 36.0% 30.0% 24.0% 18.0% 12.0% 6.0% 0.0% 0.0% 40.0% 35.0% 30.0% 25.0% 20.0% 15.0% 10.0% 5.0% 0.0% 0.0% 24.0% 21.0% 18.0% 15.0% 12.0% 9.0% 6.0% 3.0% 0.0% 0.0% 20.0% 17.5% 15.0% 12.5% 10.0% 7.5% 5.0% 2.5% 0.0% 0.0% 16.0% 14.0% 12.0% 10.0% 8.0% 6.0% 4.0% 2.0% 0.0% 0.0% 12.0% 10.5% 9.0% 7.5% 6.0% 4.5% 3.0% 1.5% 0.0% 0.0% 8.0% 7.0% 6.0% 5.0% 4.0% 3.0% 2.0% 1.0% 0.0% 0.0%