Essentially, if there is nothing to return, I need the #N/A hidden and if
there is something to be returned (such as a date), I need that to be
displayed, instead of the FALSE error.

Thanks for your help!
Eva Marie

"Eva Marie" wrote:

Hi,

Thank you for your help. I just tried this and the answer is producing
"FALSE" when there is something to be returned in the cell. For example:

The formula: =IF(P27=0,"",IF(ISNA(INDEX('Ext''d
Lines'!$B$1:$CD$1,MATCH(P27,INDEX('Ext''d
Lines'!$B$2:$CD$230,MATCH($A27,'Ext''d Lines'!$A$2:$A$230,0),0),1)+1)),""))

In this case, I am asking it to return a date via the MATCH function (which
works fine without the ISNA function). When I put in the ISNA (as shown
above) and the answer should have been say, "10/13/08", it displays "FALSE"
instead.

Eva Marie


"Niek Otten" wrote:

=IF(ISNA(YourFormula),"",YourFormula)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Eva Marie" <Eva wrote in message ...
| Hello,
|
| I have a formula which is working correctly; however when it doesn't locate
| the data (as will happens sometimes), it displays the #N/A error. I would
| prefer it display a blank cell. Can someone please tell me how to do this in
| Excel?
|
| Formula: =IF(P28=0,"",INDEX('Ext''d
| Lines'!$B$1:$CD$1,MATCH(P28,INDEX('Ext''d
| Lines'!$B$2:$CD$230,MATCH($A28,'Ext''d Lines'!$A$2:$A$230,0),0),1)+1))
|
| Thanks,
| Eva Marie