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.

[Aardigspook]

Try this in D2:

Please Login or Register  to view this content.

It uses EDATE to add a number of months to the lookup you're already doing, with an IF embedded to make it 12 months if col B is Contractor (J2) but 0 months if not.

Note that this will add 12 months every year - there's no way I can see, with the data you have in the example sheet, to know when the last review was done and therefore to know if the contractor's review is due in one year or two. That would need the date of the last review to be somewhere in the sheet.

[ChemistB]

Can you just add this into your formula (after the VLOOKUP)
+ IF(B2="contractor", 365,0),"")