Bugs in vlookup?

Jan 24, 2012
Reaction score
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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question