In cell R17: Use the VLOOKUP function to return Education Bonus 1 from the appropriate table at the top of the worksheet. Copy the function down to the other cells in the column. In cell R14 use the appropriate function to answer: How many employees have an Education Bonus greater than 400? Format answer as comma style, 0 decimal. Blank 1
