Hi all,

I have a Ranking List of Junior Players for my club and i have deviseda
ranking system for them to gain ranking points. Basically what i want to do
is have the list on 1 work sheet and on another worksheet is where i enter
the details:

01 Joe Bloggs vs 02 John Smith
Game 1 11 vs 3
Game 2 3 vs 11
Game 3 11 vs 3
Game 4 3 vs 11
Game 5 3 vs 11
Result 3 vs 2

From that data i want to check the position that they are currently in and
from that i want excel to work out the amount of points the winner will
receive and the amount of points the loser will lose from my ranking system
table.

Does this make sense, look forward to any ideas...