I used this formula for that issue:

=IF(A20="","",IF(ISNA(INDEX(AP19:AR800,MATCH(A20,A P19:AP800,0),2)),"",INDEX(AP19:AR800,MATCH(A20,AP1 9:AP800,0),2)))

Mine involves looking data up in a table, but I think the ISNA() function is
what you are looking for. Do a search for IS functions, and you will see all
of them.

Perhaps what you are looking for is something along these lines:
=IF(ISNA(your.formula), "", your.formula)

HTH!
Dave


"Todd" wrote:

I am using a formula that returns #N/A frequently and I am wondering if
there is a way using conditional formatting or a different format feature to
not have those returns show? All the #N/A make the worksheet look cluttered.

TIA


Todd