Formula in B2 and drag it down.

=IFERROR(INDEX('FINAL RESULTS'!$C:$C,MATCH(A2,'FINAL RESULTS'!$A:$A,0)),0)