If - Then

I tried this, but the result is '#N/A' when in fact the horse I am referring to finishes 1st.

=IF(COUNTA(C6:D6)=2,INDEX(RESULTS!B2:J5,MATCH(D6,RESULTS!C3:C5,0),MATCH(D6,RESULTS!A2:A5,0)),"")


Sheet 2 C6:D6 = horse number:horse name

Results C3:C5 = horse name in finishing position

Results A2:A5 = finishing position, i.e. A3=1st, A4=2nd, A5=3rd


Any help would be appreciated