Display Of Marksheet Format

I am having a data of about 500 students and

each student has 6 subjects A,B,C,D,E,and F. Now the thing is that it is not necessary that a

student must give all papers to pass in exam, it depends on what options the student has

selected. We have made a table in a form given below

RollNO. Name. A Mark Grade B Mark Grade and so on till F Mark Grade.

In the next sheet we have used the function V lookup and printed a format of marksheet as

follows:

Roll No.

Name

Subject Marks Grade

A
B
C
D
E
F
ALL USING VLOOKUP
Vlookup Vlookup Vlookup

so when in the next sheet we enter the roll no. the name field and the subject marks and grade

field all Come automatically, now let me tell u the exact problem, if a student has not given C

and E subject, because of Vlook up function ans using if function the fields in place of C and E

subject are left blank and the marksheet is not looking good. Now what i want is that if a

student has not given C paper the subject, mark and grade of D paper should come in place of C

paper place,, so that there would be no gap.. if a student has only attempted paper F instead of