lookup complicated

Hi everyone,

I've got 2 sheets Results and Data.

Results C3:C97 are student id numbers. Corresponding student ids are Data A3:A97.

I would like to pull test results from Data into Results.

Data is set up

A - Student ID, B - Test Code 1, C - Test Result (Number), D - Test Code 2, E - Test Result (Number)

So if in Results I have Stud ID in C3 and Test Code 1 is the header in D2 I want to use formula that says if Results C and Data A match, and Results D$2 = Data C return the Test result as long as Data C is greater than 0 i.e student got a mark.

Hoping someone can help. Apologies if explanation is really poor.

Thank you
Diddy