Index Match on NTH value

ryansm05

Board Regular
Joined
Sep 14, 2016
Messages
129
Code:
=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
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

ryansm05

Board Regular
Joined
Sep 14, 2016
Messages
129
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
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,109,303
Messages
5,527,899
Members
409,791
Latest member
erirog74

This Week's Hot Topics

Top