sweetpb731
New Member
- Joined
- Apr 18, 2013
- Messages
- 1
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.
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.
Last edited: