Thanks Vince,
The formula works great, I just had to change the RetentionPeriod reference
to an absolute reference to copy the formula down the column. -KS

"Vince" wrote:

In your DateToRecycle column enter the formula:
=EDATE(C2,VLOOKUP(B2,RetentionPeriod!A1:B7,2,FALSE ))
where C2 is the DateMade
B2 is the Category
RetentionPeriod is the sheet containing the table of Category and
Months

The range of the Retention Table will need to be adjust depending on the
number of Categories.

"KS" wrote:

I have a worksheet (Inventory) that contains colums for PartID, Category,
DateMade and DateToRecyle. I also have another sheet (RetainPeriod) in the
Workbook that has Category and RetentionPeriod. In Inventory when someone
enters the PartID, Category, and DateMade. I want to calculate the
DatetoRecycle based on the Category and its associated RetentionPeriod (in
months) from worksheet RetainPeriod. I know it's probably a VLookup but I
don't know how to formulate the function. Help is appreciated