VLOOKUP question

[vecia]

Hi,

I am trying to use vlookup but it is not working.

My table has 2 columns:

Text Level Numerical Level
0 0
2c 2
2b 2.33
2a 2.66
3c 3
3b 3.33
3a 3.66
4c 4
4b 4.33
4a 4.66
5c 5
5b 5.33
5a 5.66
6c 6
6b 6.33
6a 6.66
7c 7
7b 7.33
7a 7.66
8c 8
8b 8.33
8a 8.66

I am using vlookup(A1,table range,2) which is fine for some values but it just doesn't always work e.g. typing in 6b or 6a returns 5.66.

This is driving me mad, please help!

[NBVC]

Try adding a False indicator...this tells Vlookup to find an exact match...

see Vlookup in Excel help files for details...

e.g. vlookup(A1,table range,2,FALSE)

[vecia]

Excellent! Thanks very much