The problem i have trouble with is the formula in getting the letter mark for each of Faculty. I am not familiar yet in using the Match and Vlookup Function, so I am not sure where is the mistake in the formula i made.
Here is the formula: =IF(Fac="Arts",VLOOKUP(Fac,GradeTable,MATCH(Arts,A rts,Mark_Range),Arts),IF(Fac="Science",VLOOKUP(Fac ,GradeTable,MATCH(Science,Science,Mark_Range),Scie nce),VLOOKUP(Fac,GradeTable,MATCH(Graduate,Graduat e,Mark_Range))))

Here is the table:

Arts Science Graduate
0 F F F
40 E F F
50 D Pass F
55 D+ C- F
60 C C Pass
65 C+ C+ Pass
70 B B- C
75 B+ B C
80 A B+ B
85 A A- B
90 A+ A A
95 A+ A+ A

And here is the marks of each student according to their faculty with a raw mark:
Name Fac Score Grade
BERNIER Graduate 59
BINCE Arts 89
BUSHBY Arts 47
CAMPBELL Science 78
CORREIA Graduate 73
CUKIER Arts 72
DA-COSTA Science 85
DHILLON Arts 63
FERNANDES Science 48
FRASER Graduate 88
GRAVAS Graduate 95
HALL Science 48
HUNT Arts 76
IVANOVA Science 75
JOHNSON Science 75
JOLLY Arts 76
KALICHARAN Arts 78
LUSSIER Arts 74
MUHIC Science 65
NACCI Arts 68
OLDFIELD Science 63
PARK Arts 62
PAULSON Graduate 91
ROY Graduate 86
RUSSO Graduate 84
SABHARWAL Arts 61
SHERRITT Arts 41
SIMPSON Graduate 64
SIN Science 49
SMYLIE Arts 72
THOMAS Graduate 89
TJANDRA Graduate 74
TROTTER Science 73
WONG Science 87
WRIGHT Arts 85

Thanks for the help in advance,
Reuben