It is better to intercept errors or to stop them occurring, and you
can do this in a few ways, eg:

=IF(lookup_cell="","",your_formula)
or
=IF(ISNA(your_formula),"",your_formula)
or
=IF(cell_with_first_lookup="","",your_formula)

Hope this helps.

Pete

On Aug 14, 3:28*pm, janabanana
wrote:
Format text in cells that contain errors so that they don't show
Select the cells that contain the error value.
On the Format menu, click Conditional Formatting.
In the box on the left, click Formula Is.

In the box on the right, type =ISERROR(reference), where reference is a
reference to the cell that contains the error value.
Click Format, and then click the Font tab.

Click Format.
In the Color box, select white.
--
jana



"Sunny9210" wrote:
My spreadsheet is a pricing sheet with formulae using lookup in another
worksheet so it fills in the rest of the row automatically. *All rows below
what has been filled in show #N/A in one column and ### in 3 columns. *How
can I hide this so the sheet looks clean and still maintain the formulae?- Hide quoted text -

- Show quoted text -