My bet it that you have a mismatch between the parsed value you want to lookup
and the leftmost column in the lookup table.

I think I'd try to match that parsed value to whatever you have in that lookup
column.

If you have real numbers, maybe you could convert your formula:

=vlookup(if(isnumber(-(FormulaThatExtractsValue)),--(FormulaThatExtractsValue),
FormulaThatExtractsValue),sheet2!a:c,2,false)





Excel GuRu wrote:

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?

--

Dave Peterson