#VALUE! (ANY HELP)

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

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

Max

Pl stay in the same thread, keep discussions there

You say:
I have use =ISERROR((VLOOKUP.............)),
Click to expand...
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
 
Top