Formula or Macro for Scheduling, with lookup

R

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
 
F

Frank Kabel

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top