View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wu Wu is offline
external usenet poster
 
Posts: 36
Default #VALUE! (ANY HELP)

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!