I would really appreciate if someone can help me with this issue.


I have a project that will last 6 months with 31 milestones (M1 through

M152)(deadlines), and I am trying to create a calendar showing the
milestones. My goal is to create a formula that would allow me to enter

just the milestone number, and have the rest of the text auto
populated. i.e. (1=Milestone 1 = draft outline, 2=Milestone 2=meeting 1

with engineer)


So have I have been succesful to come up with the following formula:


COLUM A:
Cell A1 M1: Draft outline
Cell A2 M2: Draft Presentation
Cell A3 M3: Draft Cover Letter
Cell A4 M4: Draft Management
Cell A5 M5: Staffing


COLUM B, cell B1:
=if(B1=1,A1, if(b1=2,A2,if((b1=3,A4, if(b1=5,A5)...


Since I have 31 of these milestones, I did this 5 a times and named the

range.
M1 through M7 = m1tom7
M8 through M14= m8tom14
M14 through M20 = m14tom20
M20 through M26 = m20tom26
M26 through M31 = m20tom26


Then I concatenated the formula, as follows:


=concatenate(m1tom7,m8tom14,m1*4tom20,m20tom26,m20 tom26)


This is where I am stuck. This only works for cell B1. I do not know
how to make this work for every single cell in the calendar.


I also cannot figure out how can I "hardcore" this fomula into each
cell, so I only enter the number into the cell, and it will
automatically know to change it to the milestone number. i.e.. I enter
1 in b2, b2 shows M2:Draft Presentation.


Any help will be greatly appreciated.


Eckecko.


Reply