1) Add an additional column to the YTD Salary Expense Report (insert column B) that will list the Employee Department for each employee respectively. perform the Vlookup. * I need the EXACT formula to use in cell B5. I only have my professor's PowerPoint to reference to and nothing in the textbook. as you can see, the formula I used according to her PowerPoint gave me an error.

Perform Vlookup using these two reports so that we can see the Employer's Department on the YTD Salary Expense Report

2) Once the Vlookup is complete for all rows, sort the data by Department (A to Z) then by YTD Salary (Largest to Smallest)

* I need step-by-step detailed instructions on how to do this please

B E G H A Employee Number + ionc 5 121 8 130 9 198 220 LL 145 152 205 107 4 Employee Department Accounting Accounting Accounting Accounting Accounting Accounting Human Resources Human Resources Human Resources Lower Level Management Lower Level Management Lower Level Management Lower Level Management Sales Sales Sales Sales Sales Sales Sales Upper Level Management Upper Level Management C Employee Name Larson, Shelly Kyle, Lexi Brown, Christine Neon, Amber Axel, Larisa Rodriguez, Erica Noel, Larry Erronson, Barry Oliver, Karel Kelley, Lois Williams, Jack Temple, Sara Hernandez, Manny Cally, Eric Smith, Larry Brickell, Lisa Peterson, Emily Larson, Christopher Johnson, Carl Cooper, Aaron Moore, Anderson Maxwell Laura 15 16 166 182 105 19 106 20 176 21 188 22 190 23 197 24 221 25 101 26 135 27 28 29 30 Instructions Employee Listing YTD Salary Expense Report Excel File Home Insert Draw Page Layout Formulas Data Anna Kochetova Review AK View Help B5 =VLOOKUP(A5, 'Employee Listing'!A5:326,"2") B C D 2 Jaxson Motor Co. E F G H I K M N 3 4 5 Employee Number Department 101 #N/A 105 6 7 106 8 107 9 110 10 113 11 121 12 127 13 130 14 135 YTD Salary 235,000 101,000 98,000 175,000 190,000 48,000 45,000 41,000 42,000 220,000 55,000 65,000 185,000 76,000 145,000 95,000 88,000 116,000 33,000 50,000 30,000 105,000 15 Employee Name Moore, Anderson Cally, Eric Smith, Larry Kelley, Lois Williams, Jack Larson, Shelly Kyle, Lexi Brown, Christine Neon, Amber Maxwell, Laura Noel, Larry Erronson, Barry Temple, Sara Brickell, Lisa Hernandez, Manny Peterson, Emily Larson, Christopher Johnson, Carl Axel, Larisa Oliver, Karel Rodriguez, Erica Cooper, Aaron 145 16 152 17 166 18 176 19 182 188 20 21 190 22 197 198 23 205 24 25 26 220 221 2,238,000 28 Total 29 12 YTD Salary Expense Report instructions Employee Listing Expense O