Hi all,
I have one sheet showing a Gantt chart. This is based on the 'and' function and True or False. This works. However I am trying to calculate 'Disciplines' on T2, which should only calculate if the corresponding date is NOT false on the Gantt.
I thought I had got it based on the below, but this does not seem to work as clean as I would like. I am uploading the workbook in the hope someone can give their view.
=IFERROR(IF(INDEX(Gantt_FTE,MATCH($B5,'T1'!$AC$3:$AC$32,0),MATCH(D$4,'T1'!$AE$2:$BP$2,0)<>"FALSE"),INDEX(Gantt_FTE,MATCH($B5,'T1'!$A$3:$A$32,0),MATCH($C5,'T1'!$AD$2:$AF$2,0))),0)
Any thoughts would be most appreciated.
Thanks,
-CL
Bookmarks