How can I get N/A not to appear

[phillb]

Hi I am trying to use vlookup to search for certain items of data in an excel sheet. I understand that N/A appears when there is a problem with data, but the probelm is a deliberate one. How do I get excel to stop displaying N/A. Is htere a method of turning the error function off??

[arthurbr]

replace your_formula with
=if (iserror(your_formula),"",your_formula)

[SamuelT]

Alternatively, you can apply Condition Formatting to the cells: Format > Conditional Formatting. Choose 'Formula is' from the drop down menu and type (presuming you are in cell A1) =iserror(a1). Then change the font color to that of your background.

The error remains, but cannot be seen.

HTH,

SamuelT