That was it. I was adding (alternate columns); summing solves the problem.
Thank you all for the suggestions.
WAL50

"David Biddulph" wrote:

"wal50" wrote in message
...
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?

Are you actually summing the column (with the SUM fumction), or are you just
adding the values?
I find that SUM() can cope with blanks, but addition doesn't.
--
David Biddulph