why are blank cells returning a 'zero' - instead of blank ?
Posted by Sandy on May 05, 2001 1:10 AM
First post -I'm a novice - but I've learned all I know from these pages!
This is the formula :(say it's in cell R48)
=IF(ISERROR(VLOOKUP(R46,$A$3:$C$550,2,FALSE)),"error muster nmbr missing ",VLOOKUP(R46,$A$3:$C$550,2,FALSE))
(the formula looks up names in col 2)
When I set up the s/sheet originally, if the 'R46'
ref (in col 2) was blank, the cell R48 reflected the blank.
If there was a name in the cell, it reflected the name.
However, if I now delete the name (using the delete key)cell
R48 shows a 0 (zero)instead of a blank cell.
Could someone help me out here? (be gentle with me!)
Thanks in advance