1

I've trying to make a simple task list in Microsoft Excel 2012:

Task#  Parent Task#  Task Description  Days  Due Date
1                    Catch the llama   1
2      1             Shave the llama   1
3      2             Paint the llama   3     31/3/2012

In the "Due Date" column I want to be able to do the following calculation:

If a child task has a parent task then subtract the number of days the parent task will take from it's due date for the due date of the child task.

So "Shave the llama" would have a "Due Date" of "28/3/2012" as it would subtract the 3 days it takes to "Paint the llama", which is it's parent task.

To achieve this I need to search the "Parent Task#" column and then reference additional cells on the matched row.

How would I achieve this?

2

E2==E3-VLOOKUP(A2,$B$1:$D$3,3,FALSE)
E1==E2-VLOOKUP(A1,$B$1:$D$3,3,FALSE)

Right?

Vlookup should do what you want.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.