Trying to lookup name with reference to salary amount...with duplicate salaries.

Here is the problem I am faced with,
I am trying to figure out the players with the highest salaries, so I have the highest salaries of the year already located and in column N. I am trying to lookup which player earns each of these salaries, but when I run into duplicate salaries, it will only return the first person in the list of players with that salary for each cell (I know that is how index/match works). So I tried the formula in the formula bar to combat this issue, but I don't know why it won't work. What I'm basically trying to say with this formula is...If there are more than one of the same salary, use this complicated function to lookup the player, if not, use the simple index/match function. The formula in the [value if true] section works (that is why the highlighted cells appear to be the correct players), but only with the players with duplicate salaries. I can not just use that formula for the whole list. So what I have done in column M is used the simple index/match formula for unique salary values and used the longer formula for duplicate salary values. But, I want this to all be in one formula that I can drag for the whole list in the interest of time because as you can see, I have to do this for multiple years. I do not know why I get errors when I use this formula for the rest of this list (column O). Any help is appreciated.
Capture.PNG

Try
M2=INDEX($B$2:$B$29,MOD(LARGE(INDEX(ROW($B$2:$B$29)+$C$2:$C$29*1000,),ROW(A1)),1000)-1)

An uploaded copy of a cutdown version of the workbook would be more useful to enable a solution to be found for you.
torachan.

This worked, but the names with duplicate salaries get matched from bottom of the list to the top (last to first person with the same salary). This isn't a problem, just curious as to why it did that.

Originally Posted by congnt92

Try
M2=INDEX($B$2:$B$29,MOD(LARGE(INDEX(ROW($B$2:$B$29)+$C$2:$C$29*1000,),ROW(A1)),1000)-1)

This worked, but the names with duplicate salaries get matched from bottom of the list to the top (last to first person with the same salary). This isn't a problem, just curious as to why it did that.

Originally Posted by torachan

An uploaded copy of a cutdown version of the workbook would be more useful to enable a solution to be found for you.
torachan.

Will do from now on. Thanks.