PHP:
=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 Turnover and Cost of Sales. I need this Index/Match to look down column A at the project codes, but return the values relating to Cost of Sales and not the first which is Turnover.
Any help would be great!
Thanks
Ryan