K
kritter286
Hello
I am having trouble returning some looked up data. I have several
worksheets that I want to pull data from one "User Input" sheet. I am
running into a problem when my user input sheet has two or more rows with the
same date. For example, my "User Input" sheet looks something like this:
Week End Date Task Action Smith Jones Total
3/20/2009 Task 2 Task 2 - Action 2 0.5 1.4 1.9
3/20/2009 Task 2 Task 2 - Action 3 2 0.8 2.8
I have a separate sheet for each task and action. I have a list of dates on
each of those sheets. I want to look up the date on the sheet for "Task 2 -
Action 2" in the "User Input" sheet, then look up "Task 2 - Action 2" and
return the total hours worked for that week. Then, I want to do the same for
"Task 2 - Action 3". However, I can not get it to find the second occurance
of the date to look up the "Task 2 - Action 3" total. I think it sees the
first ocurance, looks for the action, finds "Task 2 - Action 2", and returns
"0" since it did not find "Task 2 - Action 3". Right now I am using the IF
and VLOOKUP functions. They work just fine as long as I only have 1
occurance of the date.
I hope this makes sense. I am using Excel 2003.
Thank you for your help!
I am having trouble returning some looked up data. I have several
worksheets that I want to pull data from one "User Input" sheet. I am
running into a problem when my user input sheet has two or more rows with the
same date. For example, my "User Input" sheet looks something like this:
Week End Date Task Action Smith Jones Total
3/20/2009 Task 2 Task 2 - Action 2 0.5 1.4 1.9
3/20/2009 Task 2 Task 2 - Action 3 2 0.8 2.8
I have a separate sheet for each task and action. I have a list of dates on
each of those sheets. I want to look up the date on the sheet for "Task 2 -
Action 2" in the "User Input" sheet, then look up "Task 2 - Action 2" and
return the total hours worked for that week. Then, I want to do the same for
"Task 2 - Action 3". However, I can not get it to find the second occurance
of the date to look up the "Task 2 - Action 3" total. I think it sees the
first ocurance, looks for the action, finds "Task 2 - Action 2", and returns
"0" since it did not find "Task 2 - Action 3". Right now I am using the IF
and VLOOKUP functions. They work just fine as long as I only have 1
occurance of the date.
I hope this makes sense. I am using Excel 2003.
Thank you for your help!