Hide the contents of cell

[Canon]

Excel 2007
I am using the following formula;
=VLOOKUP(C14,Sheet2!$A$1:$C$295,3,FALSE)
but I do not want #N/A to show up in the unused cells - can i hide this?

 

[Jacob Skaria]

Use ISNA() or ISERROR()

=IF(ISNA(formula),"",formula)

=IF(ISNA(VLOOKUP(C14,Sheet2!$A$1:$C$295,3,FALSE)),"",VLOOKUP(C14,Sheet2!$A$1:$C$295,3,FALSE))

 

[Setyo - Surabaya]

Can some of you send the attachment, itried but failed btw.

Thanks

 

[David Biddulph]

This newsgroup is not a binary newsgroup; it does not have attachments.