#VALUE! (ANY HELP)

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

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!

 

[Max]

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

---