Spreadsheet Salary Vlookup There Are Two Tables Of Data In The Spreadsheet The Combined Table And The Salary Table You 1 (23.81 KiB) Viewed 55 times
Spreadsheet Salary VLOOKUP There are two tables of data in the spreadsheet, the Combined table and the Salary table. Your tasks are as follows: | Use the VLOOKUP function to populate the Salary column in the Combined table with the proper corresponding value from the Salary table based on the Employee ID. Then, use the IF function in the Bonuses column to give an 8% bonus to any Employee who is in Division 105. Employees not in division 105 should get a 0. Once the cells in yellow are complete, click Run Checks to see if your solution is correct. Do not change the default cell formatting in the
Combined table Employee ID First Name 5 Daniel 12 Arnold 66 Lisal 2 Mary 24 Dennis 77 Larry 3 Mark 105 Robert 44 Susan Last Name Smith Sully Roberts Dial Front Weis Red Knight Wall Division ID 100 101 100 105 103 104 102 105 105 Manager ID 133 -1 -1 467 -1 35534 133 12353 577 Salary Bonuses
Salary table Employee ID 56 66 23 2 77 105 44 24 12 Salary 40000 80000 65000 86000 75000 75000 110000 90000 60000
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!