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
|