hiding formula #N/A message?

Posted by Dargan on January 16, 2002 2:14 PM

I have created a spreadsheet that includes several VLOOKUP formulas and need to hide the #N/A error message so that cells just appear blank when not used. Any help for this issue?

Posted by Adam S. (nt) on January 16, 2002 2:21 PM

=if(ISNA(Vlookup(blahblah))=true,"",Vlookup(blahblah))

Posted by Dargan on January 16, 2002 3:14 PM

Thanks Adam S. that did it