Update a cell with a specific value related to a date.
I think I am doing a terrible job of explaining what I am trying to accomplish.
Let me give a little back ground.
A) I have five developers, at the begining of a project they gave me an
estimate of the amount of time they could each devote to the project. On the
last day of the project there would be 0 avalible hours left.
B) Based on this data and the duration of the project I then calculated the
amount of avalible work left per developer per day.
C) Since I have calculated the amount of work avalible per dev per day in
the array I would like to come up with a formula that would update the
available column each day with the already calculated value for each Dev. I
am making the assumption that somewhere I will need to use the Today()
function to trigger which value gets placed in the avalible column.
--
Jeff
"John Michl" wrote:
I think I see where you are going. Let's try this.
Assume the word "Available" is in cell B2. Move it to B1 and put the
date 12/7 in B2. In cell B3 enter the formula,
index(E3:H3,1,MATCH($B$2, $E$2:$H$2))
Copy this formula down and you should be good to go.
- John
|