I have run a vlookup function, there are "#value!" shown on some cells.

How can I change these cells to blank, I dont want to show "#value!".

I have use =ISERROR((VLOOKUP.............)), but there is still a "1" shown
in the cells. I dont want to show anything in the cells when the results is
#value!

Pl stay in the same thread, keep discussions there

You say:
I have use =ISERROR((VLOOKUP.............)),
but hey, that's not what I suggested.

My suggestion was:
Try trapping it with ISERROR, like this:
=IF(ISERROR(VLOOKUP(...)),"",VLOOKUP(...))

If you frame it up as per the above expression,
you should get the desired results. Try it again
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---