IF formulas with Index(array) using isna

[sweetpb731]

I am using and INDEX array and have opted to leave the #N/A blank using ISNA logic.

Now I'm trying to use an IF formula against the array in another cell but I'm having a problem with the cells that were originally #N/A. They're showing up as True but I want it to show as blank as well.

Here's an example of my array formula:
{=IF(ISNA(INDEX('04.18.13'!$A$2:$R$1253,MATCH(B3&C3,'04.18.13'!$G$2:$G$1253&'04.18.13'!$I$2:$I$1253,0),2)),"",INDEX('04.18.13'!$A$2:$R$1253,MATCH(B3&C3,'04.18.13'!$G$2:$G$1253&'04.18.13'!$I$2:$I$1253,0),2))}

Here's my IF formula for the same row:
=IF(E3>$D$2,"Y","R")
I'm sure I'll have to do some kind of nested formula, but I'm not sure how to go about it.

Any help would be greatly appreciated.

 

[Derek Brown]

Hello and welcome to The Board.
Assuming that the array formula is in column E then it could be something like:
=IF(E3="","",IF(E3>$D$2,"Y","R"))
If using Excel 2007 or later you could use IFERROR instead of ISNA to reduce the length of your formulas.