Hide the contents of cell
 

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?

Hide the contents of cell
 

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))
--
If this post helps click Yes
---------------
Jacob Skaria


"Canon" wrote:

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?

Hide the contents of cell
 

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

Thanks

"Jacob Skaria" wrote:

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))
--
If this post helps click Yes
---------------
Jacob Skaria


"Canon" wrote:

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?

Hide the contents of cell
 

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

"Setyo - Surabaya" <Setyo - wrote in
message ...
Can some of you send the attachment, itried but failed btw.

Thanks

"Jacob Skaria" wrote:

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))
--
If this post helps click Yes
---------------
Jacob Skaria


"Canon" wrote:

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?