Vacation hours accrued based on Seniority Date

Hello friends,
I am here again to find out a way of calculating vacation hours accrued based on continuous years of service completed for next year (2015). Attached is an example of a similar file that I used to track vacation accrued. In the Roster worksheet, I have the continuous years of serviced completed in column B, and in column E is where I need an Excel formula and gives me the correspond number of vacation hours. The policy for vacation states: The amount of vacation depends on the employee's continuous length of service with the company, measured on the
last day of the calendar year in which such vacation is earned.
AMOUNT OF SERVICE VACATION
Employed before January 1st of the current year, but less than five years of continuous service completed prior to January 1st of the current year. Ten (10) Days
Five years of continuous service, but less than fourteen years service completed prior to January 1st of the current year. Fifteen (15) Days

Fourteen years or more years of continuous service completed prior to January 1st of the current year. Twenty (20) Day

NEW EMPLOYEE
Eligible employees hired after January 1st of the current calendar year shall receive vacation to be used in the
current year based on the month of hire as follows:
Calendar Month of Hire Vacation Days
January 10
February 9
March 8
April 7
May 6
June 5
July 4
August 3
September 2
October 1
November 0
December 0

Again, thank you everyone for taking the time to help and read my post.

Does this do what you are after?

Thank you FlameRetired for your help. However, if you filter the data by Column B (YearsOfService2014) by 5 years, all of those employees should have 120 hours available in 2015 not in 2014 because the policy states Five years of continuous service, but less than fourteen years service completed prior to January 1st of the current year. Fifteen (15) Days.
Your vlookup formula only obtains the corresponding value from the vacation table. Is there away to accomplish this task? Anyone's help would be greatly appreciate.

...........In the Roster worksheet, I have the continuous years of serviced completed in column B, and in column E is where I need an Excel formula and gives me the correspond number of vacation hours.

However, if you filter the data by Column B (YearsOfService2014) by 5 years, all of those employees should have 120 hours available in 2015 not in 2014 because the policy states Five years of continuous service, but less than fourteen years service completed prior to January 1st of the current year. Fifteen (15) Days.

Yes, you're right. From post #1 that is what I understood you to want in column E.

I do not understand the policy described in post #1. I am challenged to find the questions that I should ask.

So I'll start with these:

From your first post it was my understanding you had already determined the YearsOfService2014/2015 in columns B and C. Did I get that wrong?

If so are you requesting formula....based on the policy......for determining those years of service?

In the attached I took the liberty of adding a column F that does what column E does but for 2015. I then added another sheet RosterRework in which I attempted a formula for determining years of service (columns B and C)....based upon the policy (to the best of my understanding). Do these formulas yield the results you are expecting?