Formula Help, LOOKUP, INDEX...(?)

[Guest]

Hi,

Let me preface this by saying I have limited experience with formulas (and,
frankly, Excel).
I've got two workbooks - ONE logs in time spent on a task for each day of
the year, TWO is a weekly timesheet.

I want TWO to retrieve the data from ONE where the dates match and there is
a time entry for the date & task -- filling in the task & time spent in the
appropriate column. (As the year progresses the tasks list will grow longer
and they may not be performed every day.)

ONE (task list) is like this:

US Sales Task 6/11/07 6/12/07 6/13/07
6/14/07 etc-yr end
Disk Cleanup
File Correction 0.25
0.75
Sys144 2.00

Foreign 2067-F 0.25 0.5
1728-F
3.00

Canadian 1821-X
2153-X 0.25

TWO (timesheet) is like this:
US Sales
Task 6/11/07 6/12/07 6/13/07 6/14/07 6/15/07
TotalWeeklyHours
(Task1)
(Task2)
(Task3)
TotalUSDaily

Foreign
(Task1)
(Task2)
(Task3)
TotalForeignDaily

Canadian
(Task1)
(Task2)
(Task3)
TotalCanadianDaily

Totals Daily
(TotalWeeklyHours)

I've tried a few different formulas that use INDEX, MATCH, LOOKUP, etc. but
I cannot get it work.

Can anyone provide some assistance?

Thanks, Pat

 

[Guest]

Sorry, ONE (task list) is like this:
A B C D E
1 US Sales Task 6/11/07 6/12/07 6/13/07 etc
2 Disk Cleanup
3 File Correction 0.25 0.75
4 Sys144 2.00
5
6 Foreign 2067-F 0.25 0.5
7 1728-F 3.00
8
9 Canadian 1821-X
10 2153-X 0.25