Index Match on NTH value

[ryansm05]

=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

 

[Aladin Akyurek]

Does A4 always occur twice?

 

[ryansm05]

Hi Aladin,

Yes - A4 and A5 will be the same ... please see link - my index/match is picking up cell L4 and not L5 because the latter is obviously not the first instance.
I'm open to using a different formula if you have any suggestions.

https://ibb.co/jQR4Cd

Thanks
Ryan

 

[Aladin Akyurek]

Try to post a scaled-down Excel readable sample along with the expected outcome.