Wal50 --

Try not using " ", but "". The first puts a space in the cell (you just
can't see it), but the second actually leaves it blank.

HTH

"wal50" wrote:

I am using the following which puts a 0 in the field when the lookup finds no
match.
=IF(ISERROR(VLOOKUP($D191,'0604'!$A$1:$E$141,5,FAL SE)),0,VLOOKUP($D191,'0604'!$A$1:$E$141,5,FALSE))
This works fine except I don't want a 0, I want a blank. But when I use " "
instead of 0, the cell shows as blank but when I sum that column I get #Value!
Any ideas?
Thanks
WAL50