Need Help With Nesting an IFNA Statement

[CERipkenJr]

Hi there, I have this formula currently, but want to nest an IFNA statement so that if there is an #N/A returned in the cell, that it displays a "-" instead:

=INDEX('Critical Dates Export'!$AB$2:$AB$99,MATCH(A6,'Critical Dates Export'!$L$2:$L$99,0))

I'm having difficulty with the syntax and where to put it. Any pointers are greatly appreciated.

 

[Norie]

Try this.

=IFNA(INDEX('Critical Dates Export'!$AB$2:$AB$99,MATCH(A6,'Critical Dates Export'!$L$2:$L$99,0)), "-")

 

[dreid1011]

One of three ways:

=IFERROR(INDEX('Critical Dates Export'!$AB$2:$AB$99,MATCH(A6,'Critical Dates Export'!$L$2:$L$99,0)),"-")

Or

=IF(INDEX('Critical Dates Export'!$AB$2:$AB$99,MATCH(A6,'Critical Dates Export'!$L$2:$L$99,0))="#N/A","-",INDEX('Critical Dates Export'!$AB$2:$AB$99,MATCH(A6,'Critical Dates Export'!$L$2:$L$99,0)))

Or

=IFNA(INDEX('Critical Dates Export'!$AB$2:$AB$99,MATCH(A6,'Critical Dates Export'!$L$2:$L$99,0)),"-") compliments of Norie xD

 

[CERipkenJr]

Seriously? I post this and it's answered in 2 minutes. Y'all are freaking amazing. How is it that I got the index & match down, but this IFNA statement was putting a pretzel in my head - this was such an easy fix and I feel like a total dope. In any event THANK YOU.