Sweenster,
you are right, you are very close. I assume Score is the name of the
cell with the label "Score". If so, you just need to add 1 to MATCH().

=OFFSET(Score,MATCH(D6,ScoreCard!C4:C14,0)+1,0)

HTH
Kostis Vezerides