Issue with Index Match with duplicates

[richard1234567891011]

Hi Guys, I have an issue with duplicates match formula, the issue is this:

[/URL][/IMG]


Pescara is wrong. I would like to have a formula that can choose the second one, so Chieti.
The actual formula is very simple, it is: =INDEX(B2:B11;MATCH(G2;C2:C11;0)) (in order to find Pescara) but this formula is not able to recognise that the second 375 is not for Pescara but for Chieti.

I would like a general formula, because this is a simplified example.

Thank you very much guys.

 

[JustynaMK]

Hi Richard,

Try this Array formula (Ctrl+Shift+Enter):

=INDEX($B$2:$B$11,MATCH(0,COUNTIF($F$1:F1,IF($C$2:$C$11=G2,$B$2:$B$11,"")),0))

Final result:

Hope it works for you.