Hi,

I'm using VLOOKUP to to convert a set of cells with values based on a lookup
table. Some of these defined values are "C--" and "C-" as per the example
below. Does anyone know why the formula does not give the correct answer?

A B
1 C-- 1
2 C- 2
3 C 3
4 C+ 4
5 C++ 5
6
7
8 C++ 5
9 C+ 4
10 C 3
11 C- 3
12 C-- 3

(B8 fomula =VLOOKUP(A8,$A$1:$B$5,2) delivers correct value)
(B9 fomula =VLOOKUP(A9,$A$1:$B$5,2) delivers correct value)
(B10 fomula =VLOOKUP(A10,$A$1:$B$5,2) delivers correct value)
(B11 fomula =VLOOKUP(A11,$A$1:$B$5,2) delivers incorrect value, should be 2)
(B12 fomula =VLOOKUP(A12,$A$1:$B$5,2) delivers incorrect value, should be 1)

I have tried changing the order of column A array, changing the cell format
of column A to text/general but with the same result. If I replace C-- and C-
with something else then it works. Have tried it with both XP/Excel 2003 and
XP/Excel 2007

Any suggestions please?
/Exxet