Maybe my original post wasn't clear enough. I'm trying to lookup using cell
h9 which contains a formula such as =left(k9,1) If I key in a figure i cell
h9, the lookup formula works, but with the formula calculating, it
doesn't(unless the result of the formula is a letter).

Please let me know if you have any other ideas. We encounter this frequently.

"RagDyer" wrote:

You could try to revise your parsing formula to return "true" numbers:

=IF(ISERROR(--RIGHT(A1)),RIGHT(A1),--RIGHT(A1))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Excel GuRu" wrote in message
...
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?