Deduct Highests Scores By Condition

[ratcat]

G'day,

After scratching my head for a while I realised what your trying to explain. Then scratched my head some more to make it work automatically and now I have a large gaping hole in my head. Hahahaha.

Then this workbook popped out.

Edit: Did not allow player to be under Par. Please replace the formula in cell X10 with this one.

=IF(Z10=0,W10,W10-IF(Z10=0.5,OFFSET('Scoring Database'!A3,0,VLOOKUP(Z10,Half,2,FALSE))/2,SUM('Scoring Database'!A3:OFFSET('Scoring Database'!A3,0,AB10-1))+IF(ISNA(VLOOKUP(Z10,Deduction,1,FALSE)),0,OFFSET('Scoring Database'!A3,0,VLOOKUP(Z10,Half,2,FALSE)-1)/2)))