Left Lookup formula works but requires tweaking

Morning all.

I am trying to set up a score ranking sheet for my EPL fantasy pub league.

In doing so I have used a VLOOKUP & CHOOSE formula which does work, however if a score is tied the formula only returns the 1st name and ignores the 2nd name.

Formula used =VLOOKUP(F2,CHOOSE({1,2},$C$2:$C$7,$A$2:$A$7),2,FALSE)

My question is: Can this formula be tweaked to pick up the 2nd name or should I just bite the bullet and use a helper column ?

Bite the bullet, and use a helper column.

FYI, While that is a neat trick to do a left vlookup, Index/Match would be simpler and more efficient

=INDEX($A$2:$A$7,MATCH(F2,$C$2:$C$7,0))

Thanks Jonmo,

I actually realized after posting that there is nowhere within the formula that could be tweaked.

You are right of course about INDEX MATCH but I like to push the envelope :-)