Excel

[eckecko]

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,m14tom20,m20tom26,m20tom26)

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 M2raft Presentation.

Any help will be greatly appreciated.

Eckecko.

 

[aaron.kempf]

use Access, excel isn't meant for data entry.

-Aaron

 

[Adam]

I beg to differ, In Excel use Data > Forms