Mumps,

There are three examples in the file already, and the expected results are shown in COl E, headed "S/Be".

In row 2, there is an "actual" grade (2) in Col B. So the Code needs to look in Col I for whatever matched "2" in Col H - the answer is 3, as shown in E2.
In row 3, there is no "actual" grade in Col B, so the code needs to look at the value in Col A (2) and find the equivalent for that - the answer is 3, as shown in E3
In row 3, there is an "actual" grade in Col B (D), so the code needs to look in COl I for that equivalent - the answer is 4, as shown in E4

Hope that will hep find the flaw in the VBA code?

Ochimus