I am trying to produce a spreadsheet for a golf society competition. I want
handicaps reduced each round based on the ranking of each competitor for that
round , eg

H'cap Points Position Total

Course 1 7 1

Course 2 5 2

Course 3 4

If a player comes first his handicap is reduced by 2, if second by 1, etc

How can I get the spreadsheet to look at the position cell, identify the
position, allocate the reduction based on that and then put it in the
handicap cell for course 2 by deducting that reduction from the handicap 1 ie
7 minus 2 for winning at course 1, 5 minus 1 for course 2 so that his new
handicap for course 3 will be four.

I have failed with both IF and LOOKUP! Any ideas most welcome

Geoff