What i can't seem to find out:

For school i made a matrix in which 20 students could score points in
different subjects. Each score was added up, so that each student had a total
score.
Of those total scores i made a Ranking table. I've used excel to put the
scores into assending order and then used the (vertical) look-up function to
find the name that matches the score.
this works perfectly, until there are 2 identical scores. Excel then picks
the first name, for both scores. How can i 'tell' excel to look further in
the directed matrix, if the name found is already used in an earlier cell?
I tried using the If-fuction, but that didn't work.
If anyone knows how to solve this or can be of any help, i would appreciate
it if you replied.
Thanks in advance.

Sven
The netherlands (so also using dutch version, but thats ok)