#value!
Thanks, but the result is the same. Still get #value! when I sum. The sum
works when I replace with 0.
WAL50
"Domenic" wrote:
Try...
=IF(ISNA(VLOOKUP($D191,'0604'!$A$1:$E$141,5,FALSE) ),"",VLOOKUP($D191,'060
4'!$A$1:$E$141,5,FALSE))
Then use the SUM function to sum. It ignores text values, including
formula blanks. So, for example, you could try something like this...
=SUM(A2:A10)
or
=SUM(A2,A5,A10)
Hope this helps!
In article ,
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
|