Referencing or lookup function possibly?

Hello,

I'm looking for a formula that can pick out the number of votes a party receives in a constituency. If the Conservative party won the constituency, then I want the number of votes the party in second achieved, if the Conservative party lost the constituency, then I want the number of votes the winning party achieved. I've attached an excel file which should make this clearer.

Thanks in advance for any help!

Thanks for the suggestion, I have thousands to do so need a less manual procedure though

Building off of loginjmor's idea, you can put the formula below in S4 and just fill down. It should cover you as you add more constituencies or even switch parties.

=IF(VLOOKUP($M4,$B:$D,3,FALSE)=$N4,INDEX($E:$E,MATCH($M4,$B:$B,0)+1),VLOOKUP($M4,$B:$E,4,FALSE))

This is very close to working except it always seems to return the votes of the winning party, even when the winning party is the Conservative party. If the Conservatives are winning I would like the 2nd placed number of votes to be produced. Is it possible to adjust the formula slightly to make this happen? My idea would be to reference one below but I'm unsure how to do this?

Duh. Sorry. Fixed:

=IF(VLOOKUP($M4,$B:$C,2,FALSE)=$N4,INDEX($E:$E,(MATCH($M4,$B:$B,0)+1)),VLOOKUP($M4,$B:$E,4,FALSE))

Enter in S4 and fill down

Thanks, this is exactly what I was after!