On Dec 11, 10:56*am, ritpg wrote:
I've got the following Excel sheet in which the work figures represent
the weekly and cumulative hours in a person's hours budget:

* * * * * * * * * * * * * * * *05-Jan-09 * 12-Jan-09 * 19-Jan-09
etc.
Joe Smith
* *Work * * * * * * * * * * * *40 * * * * * *40 * * * * * * *35
* *Cumulative Work * * * 40 * * * * * *80 * * * * * * *115
Mary Jones
* *Work * * * * * * * * * * * *25 * * * * * *40 * * * * * * *35
* *Cumulative Work * * * 25 * * * * * *65 * * * * * * *100
John Jefferson
* *Work * * * * * * * * * * * *35 * * * * * *40 * * * * * * *35
* *Cumulative Work * * * 35 * * * * * *75 * * * * * * * 110
etc.

And I have a 2nd sheet as follows:

Current Date: * 12-Jan-09

* * * * * * * * * * * * * *Cumulative Hours
* * * * * * * * * * * * * *Budgeted to Date
Mary Jones * * * * * * * * * *65
Joe Smith * * * * * * * * * * *80
John Jefferson * * * * * * * *75
etc.

Note that the names on the 2nd sheet are not in the same order as the
1st sheet. *I want to be able to change the Current Date on the 2nd
sheet and have the Cumulative Hours Budgeted to Date column populated
automatically.

I know there are folks out there much smarter about Excel than I. *Any
and all inputs will be greatly appreciated.

Thanks,
Terry

I suspect the answer has something to do with a combination of the
VLOOKUP and HLOOKUP functions. Or perhaps the INDEX function would do
it. Any thoughts?

Thanks.