Hi all,
Please help, I'm quite new to index match and really struggling to work out if I'm doing something wrong or if what I'm trying to do is even possible?
I have a couple of Gantt charts, one for the projects and one for the peoples tasks.
On the peoples tasks, I have dates running across the top and people running down the left hand side. In the cells in between, in line with dates and the people, I am adding in the project ID. A project may be worked on multiple days, so the ID could be in multiple cells
What I want to do is to output the last date of the project onto the project Gantt chart. It feels like I need a nested index match to lookup the various items but whatever I try, nothing seems to work.
I've also searched for nested index match to see if this is/n't possible to no avail.
Please can someone help?
TIA
Please help, I'm quite new to index match and really struggling to work out if I'm doing something wrong or if what I'm trying to do is even possible?
I have a couple of Gantt charts, one for the projects and one for the peoples tasks.
On the peoples tasks, I have dates running across the top and people running down the left hand side. In the cells in between, in line with dates and the people, I am adding in the project ID. A project may be worked on multiple days, so the ID could be in multiple cells
What I want to do is to output the last date of the project onto the project Gantt chart. It feels like I need a nested index match to lookup the various items but whatever I try, nothing seems to work.
I've also searched for nested index match to see if this is/n't possible to no avail.
Please can someone help?
TIA