calc newbie - help find last value from table

[rolfy]

Hi There,

I've set up a little table that I want to use to do golf handicaps, and I'm mostly done. The one thing i want to do is be able to bring forward someones adjusted handicap.

Match,Player,Score,Handicap
1,rolfy,70,10
1,fred,75,15
1,frank,76,12
2,rolfy,70,XXXX

I'm looking to bring forward the "10" from the handicap column in rolfies first game to the second game. I have done this with a DGET at the moment, but where the problem comes in is if, say, frank hasn't played for a while, and I want to get his handicap last time he played (he might have played 10 matches, missed 5, then played another one).

VLOOKUP is kind of what I want to be able to do, but I want to get the LAST value that matches, not the FIRST one

Can anyone suggest a solution for this one ?

Thanks heaps