# IF formulas with Index(array) using isna

#### sweetpb731

##### New Member
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.

Last edited:

### Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

#### Derek Brown

##### Well-known Member
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.

Replies
2
Views
118
Replies
8
Views
231
Replies
14
Views
252
Replies
6
Views
492
Replies
12
Views
362

1,196,019
Messages
6,012,901
Members
441,739
Latest member
Jeezer

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back