Vlookup returning duplicates

[Vhookup]

I'm doing a fantasy football analysis that ranks players based on their value (value over positional mean (VOM)). The file is attached. In the summary tab, I'm returning the largest values and then using a vlookup to return the corresponding player. Unfortunately, if two players have the same value, the vlookup formula will return the same player twice. How can I avoid duplicates?

[TMS]

Can't do it right now but, if you want to have a go, try this:

Add a helper column
In the helper column, add the score and row()/1000000
Rank using the helper column (LARGE)
Use INDEX/MATCH using the ranked helper values to return the name

ROW()/1000000 will add a very small, and unique, amount to the score so you can differentiate them but it won't be visible.


Regards, TMS

[FDibbins]

I was looking at doingb that too, Trevor - it will work on a sheet-level, but wont necessarily work between sheets. I was looking to see if there was a way to put all the data onto 1 sheet, but that is something onkly the OP can decide on