# VLOOKUP Returning Wrong Value

Dec 14, 2006I have this formula that returns a grade mark for a specific score in a test:

=VLOOKUP(D4,'Grade scale'!$A$34:$B$42,2)

using these values in the lookup table:

Low scoreGrade

0.0% U

25.0% G

35.0% F

45.3% E

55.3% D

65.5% C

72.0% B

78.0% A

85.0% A*

The problem comes where the Grade is A or A* as the Vlookup table can't differentiate the two. Anyone know how to modify the formula so that A and A* are seen as distinct values?