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