[dominicfoo]

I entered the following data array:

A+; 0
A; 1
A-; 2
B+; 3
B; 4
C+; 5
C; 6
D; 7
E; 8
G; 9

When I tried to use vlookup to return the values in the 2nd column, I encountered the following errors:

A+ : 2 (should be read as 0)
A : N/A (should be read as 1)
B : 2 (should be 4)
C : 4 (should be 6)

Can anyone tell me how do I resolve this problem? Many thanks.