Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 2 down vote accepted



Vlookup should do what you want.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .