Vacation Time Based on Years of Service and Position

[MaryGemmer]

Hello All,

I am attempting to create a formula that takes someone's years of service and position, then calculates how many vacation days they will have. I have created a column on one spreadsheet that calculates the number of years of service, and have entered a position type (for example, "O" for Overseer, "D" for Director, etc). I would like that spreadsheet to pull information from the second spreadsheet that lists the amount of vacation earned based on years of service and position type. Attached is an example of my workbook that I am working on. Any help is appreciated.



Mary

[Tony Valko]

How about updating your sample file to show us what results you expect.

[joris moerings]

Hi,
I changed your table on PTO accrual a little to create a solution.
take a look at this and see if this what you expected.