=IF(AND($D5="Cost",$L5<0),SUM(V5+INDEX($A$3:$S$116,MATCH($A4,$A$3:$A$116,0),MATCH($V$2,$A$3:$S$3,0))),"")
Hi all,
This index/match works okay - apart from the fact I need it to look at the second (duplicated) value in column A.
For a bit of context, I have 2 identical project codes for...