when I put a number in the cell it is still putting the DNP ...

I'm confused. What exactly is this cell you are referring to?
A26? Or P1? Or the vlookup's table array?
Pl re-explain clearly your scenario
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---