Vacation Time Based on Years of Service and Position

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