If cells DI5:D20, Imported data from the rating system combines the manager's raise recommendation of High, Standard, or Low followed by the manager's notes. In cells J3:J10, use a combination of text functions to return just the manager's raise recommendation of High, Standard, or Low. The values returned should not have extra spaces before or after the word. The names in A3:A10 are in the same order as A13:A20. Notice the text pattern is always the recommendation followed by a space. Be sure to Trim any extra spaces. On the Evaluations worksheet, create the named range Evaluations for the cell range A3:J10. On the Payroll worksheet, there is an analysis for raises you need to finish. First, you need to get all the applicable data for making the raise determination on this worksheet. Add the following. In cell F1, enter a formula to always return the current date. In cells E6:E13, add a DATEDIF function that will calculate the years employed based on today's date in cell F1 and the HireDate in column B. Remember you are looking for years and not days. In cells F6:F13, add a VLOOKUP function that returns the raise recommendation-High, Standard, or Low-for each employee by exactly matching the Name in column A in the range you named Evaluations. Be sure to use exact match criteria