All Excel is telling you is that the lookup value is a constant which isn't
an issue. What exactly is the problem and why are you having to evaluate your
formula? can we see it?

Mike

"lindle101" wrote:

I am trying to do a vlookup and when I check my calculation steps it says
that 'the cell currently being evaluated contains a constant'. I am not sure
about this error. The first cell contains a 1-438 number in general format.