ExcelBanter - #value!

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - #value! (https://www.excelbanter.com/excel-discussion-misc-queries/188783-value.html)

#value!

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

Max

#value!

"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
---

All times are GMT +1. The time now is 04:10 AM.