In cells F6:F13, you will determine the raise recommendation for each employee based in an Evaluations named range from the Evaluations worksheet. In cell F6, add a VLOOKUP function that returns the raise recommendation of High, Standard, or Low for each employee by exactly matching the Name in column A (A6 for first row) to the Evaluations named range, column 10. Be sure to use exact match criteria. Add FALSE to equation Copy the formula through F13. Calibri 11AA Wrap Text Paste B I U v a Ave E Merge & Center Clipboard Font 12 Alignment 6 A B C D 1 2 3 4 Painted Paradise E Today's Date High Bonus $ Low Deduct $ 2/10/2021 750 500 RESORT & SPA Raise St. Recommend Ral Years Employed 10 11 11 10 13 10 5 Name HireDate JobTitle Salary 6 Meda Rodate 3/14/2010 Spa Manager $ 71,500 7 Christy istas 8/12/2009 Therapist $ 42,100 8 Jason Niese 8/12/2009 Massage Therapist $45,800 9 Paul Medina 2/1/2011 Coffee Shop Manager $ 35,000 10 Juanita Gomez 9/30/2007 Barista $ 29,900 11 Susan Brock 5/15/2010 Gift Shop Manager $ 37,200 12 Jay Groth 3/16/2007 Sales Associate $ 28,100 13 Kate Munson 6/4/2005 Sales Associate $ 28,700 14 Standard 15 Years Employed Raise % 16 0 2.50% 17 2 3.009 18 3.5096 19 7 4.00% 13 15 INN Evaluation Payroll In cells F6:F13, you will determine the raise recommendation for each employee based in an Evaluations named range from the Evaluations worksheet. In cell F6, add a VLOOKUP function that returns the raise recommendation of High, Standard, or Low for each employee by exactly matching the Name in column A (A6 for first row) to the Evaluations named range, column 10. Be sure to use exact match criteria. Add FALSE to equation Copy the formula through F13. Calibri 11AA Wrap Text Paste B I U v a Ave E Merge & Center Clipboard Font 12 Alignment 6 A B C D 1 2 3 4 Painted Paradise E Today's Date High Bonus $ Low Deduct $ 2/10/2021 750 500 RESORT & SPA Raise St. Recommend Ral Years Employed 10 11 11 10 13 10 5 Name HireDate JobTitle Salary 6 Meda Rodate 3/14/2010 Spa Manager $ 71,500 7 Christy istas 8/12/2009 Therapist $ 42,100 8 Jason Niese 8/12/2009 Massage Therapist $45,800 9 Paul Medina 2/1/2011 Coffee Shop Manager $ 35,000 10 Juanita Gomez 9/30/2007 Barista $ 29,900 11 Susan Brock 5/15/2010 Gift Shop Manager $ 37,200 12 Jay Groth 3/16/2007 Sales Associate $ 28,100 13 Kate Munson 6/4/2005 Sales Associate $ 28,700 14 Standard 15 Years Employed Raise % 16 0 2.50% 17 2 3.009 18 3.5096 19 7 4.00% 13 15 INN Evaluation Payroll