When I use the formula below to find corresponding items it works fine,
UNLESS there is a "tie" (two or more matches). It gives me the first one it
finds and then repeats the same matching name for all the others. How can I
get it to list each specific match and not just repeat the first one?
The formula: =index(ScoreSheet!$B:$B,MATCH(K23,ScoreSheet!$N:$N,0))
I know I can use the sort feature, but I would rather a formula.
My table is set up like this:
Name Team Score
Smith One 590