Hello,
I'm novice in excel formulae. Looking for a solution for the below problem
There are set of tasks for each product launch with due dates. For reporting purposes, I need some formula for column "Product Launch" where excel can
1) Lookup due date of "product launch" task (6th task of every product)
2) Map the due date to specific product (Ex: product X here)
3) Apply that specific product launch due date to ALL TASKS related to product X
Let's say, I'll have running excel with 100 products each having 6 tasks & different launch dates, that's total 600 repetitive tasks in single sheet. For segregating products & related tasks by 'Launch Date' I need this additional column with formula
Thanks,
Ravi N
I'm novice in excel formulae. Looking for a solution for the below problem
There are set of tasks for each product launch with due dates. For reporting purposes, I need some formula for column "Product Launch" where excel can
1) Lookup due date of "product launch" task (6th task of every product)
2) Map the due date to specific product (Ex: product X here)
3) Apply that specific product launch due date to ALL TASKS related to product X
Let's say, I'll have running excel with 100 products each having 6 tasks & different launch dates, that's total 600 repetitive tasks in single sheet. For segregating products & related tasks by 'Launch Date' I need this additional column with formula
Product Name | Task | Due Date | Product Launch |
Product X | Product requirements gathering | 2/1/2020 | 5/15/2020 |
Product X | Product design | 3/15/2020 | 5/15/2020 |
Product X | Product prototype ready | 3/30/2020 | 5/15/2020 |
Product X | Product testing | 4/15/2020 | 5/15/2020 |
Product X | Product mass production | 4/30/2020 | 5/15/2020 |
Product X | Product launch | 5/15/2020 | 5/15/2020 |
Prod Y | Product requirements gathering | 3/30/2020 | 6/15/2020 |
Prod Y | Product design | 4/15/2020 | 6/15/2020 |
Prod Y | Product prototype ready | 4/30/2020 | 6/15/2020 |
Prod Y | Product testing | 5/15/2020 | 6/15/2020 |
Prod Y | Product mass production | 5/30/2020 | 6/15/2020 |
Prod Y | Product launch | 6/15/2020 | 6/15/2020 |
Thanks,
Ravi N