"Wu" wrote:
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!".

Try trapping it with ISERROR, like this:
=IF(ISERROR(VLOOKUP(...)),"",VLOOKUP(...))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---