- Joined
- Jan 24, 2012
- Messages
- 1
- Reaction score
- 0
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.
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.