Trying to figure out a vlookup with multiple arguments

[krvargo]

I have a spreadsheet that lists employees and when their reviews are due. Currently I have a vlookup validating a date based on what tier they are. For example, Tier one is due in Mar, Tier two is due in Apr, ect.

That works perfect, but now I need to figure out a way to add 365 to that date based on a selection in another cell. For example, if they are a private contractor their reviews are every 2 years but everyone else is 1 year.

Thank you for any help and I'm open to other suggestions.