Can you please help me incorporate ISNA in this function

**JPSIMMON** · 08-24-2013, 02:29 PM

=INDEX('Raw M'!$1:$1048576,MATCH('Zone D'!$A44,'Raw M'!$A:$A,0),MATCH('Zone D'!E$55,'Raw M'!$1:$1,0))

My goal is to have cells that have NA to go blank with the use of ISNA. or IFERROR (whatever is easiest).

Thanks!!

**Jean.P28** · 08-24-2013, 02:41 PM

I think you have forget the brace (ctrl +alt+ enter)

**Tony Valko** · 08-24-2013, 02:43 PM

Since you're using Excel 2007 IFERROR is easiest.

Just place the entire formula inside the IFERROR function like this:

=IFERROR(INDEX('Raw M'!$1:$1048576,MATCH('Zone D'!$A44,'Raw M'!$A:$A,0),MATCH('Zone D'!E$55,'Raw M'!$1:$1,0)),"")