I am trying to use the vlookup function to add detail relating to one figure
in a sales part number. I have item needed in the sales part number parsed
using the a right function.

For some items the parsed value is a letter, but for most it is a number.
The vlookup function works well for those fields where the parsed value is a
letter, but when it is a number(1-8 in this case), it doesn't work.

Is there a solution? Or, is this a limitation of the vlookup function
referring to calculated cells?