Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Lookup Question
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Lookup Question | Excel Discussion (Misc queries) | |||
Excel 2003 - Lookup type of question | Excel Worksheet Functions | |||
Excel LOOKUP Question | Links and Linking in Excel | |||
Excel Lookup Question | Excel Programming | |||
Lookup Question | Excel Worksheet Functions |