#value!

W

Wu

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!".
 
M

Max

Wu said:
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!".
Click to expand...

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