Formula or Macro for Scheduling, with lookup

[Rachelynn]

I'm trying to create formulas for production scheduling. The lookup is
for how many months the product spends in each level. Products move up
levels, but based on the lookup, they move differently and skip certain
levels. The way I have it now, it shows the date in every level, even
though they may not apply. How do I delete the cells that do not apply
without creating an error in the rest of the row? I want to keep the
formulas (not paste values) and I want to be able to use the chart in
pivots. Any ideas? Any hints would be greatly appreciated!
Thank You!

Attachment filename: scheduling.jpg
Download attachment: http://www.excelforum.com/attachment.php?postid=644303

 

[Frank Kabel]

Hi
better to post some example rows in plain text and your currently used
formula. Most people won't open an attachment

 

[Rachelynn]

Lookup:
Code L0 L1a L1 L2 L3 LF
1 12 12 15
2 12 15 12
3 2 12 27 15

Code Start
1 6/04

Formula for date: L0 L1a L1 L2 L3 LF
=DATE(YEAR(b2),MONTH(b2)+VLOOKUP(A2,lookup,2,FALSE),DAY(b2))
=DATE(YEAR(c2),MONTH(c2)+VLOOKUP(c2,lookup,3,FALSE),DAY(c2))
and so on

Make any sense? Hard to visualize without being in exce