Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#value!
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 |