Making #N/A zero or -

Below is an array formula that I am using, I just can't figure out how to make it return 0 or - if there is not a number that meets the specified conditions. I've tried adding ISERROR in front of it and various other places, but I haven't been able to get it to work....perhaps I'm putting it in the wrong place or missing something that should go with it. Any help is appreciated! Thanks!

=(INDEX($Q$2:$Q$2000,MATCH(1,(4=$L$2:$L$2000)*(100%=$M$2:$M$2000)*("Public Opinion"=$J$2:$J$2000)*("x"=$R$2:$R$2000),0)))

Too complicated to get head around at this hour but in general one uses this
syntax
=IF(ISNA(your_formula, 0, your_formula)
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"shikamikamoomoo"
<shikamikamoomoo.253ega_1143066900.8944@excelforum-nospam.com> wrote in
message news:shikamikamoomoo.253ega_1143066900.8944@excelforum-nospam.com...
>
> Below is an array formula that I am using, I just can't figure out how
> to make it return 0 or - if there is not a number that meets the
> specified conditions. I've tried adding ISERROR in front of it and
> various other places, but I haven't been able to get it to
> work....perhaps I'm putting it in the wrong place or missing something
> that should go with it. Any help is appreciated! Thanks!
>
> =(INDEX($Q$2:$Q$2000,MATCH(1,(4=$L$2:$L$2000)*(100%=$M$2:$M$2000)*("Public
> Opinion"=$J$2:$J$2000)*("x"=$R$2:$R$2000),0)))
>
>
> --
> shikamikamoomoo
> ------------------------------------------------------------------------
> shikamikamoomoo's Profile:
> http://www.excelforum.com/member.php...o&userid=21018
> View this thread: http://www.excelforum.com/showthread...hreadid=525491
>

You could use this kind of technique:

=if(iserror(Match(1,....)),0,your existing formula)

Still array entered.

shikamikamoomoo wrote:
>
> Below is an array formula that I am using, I just can't figure out how
> to make it return 0 or - if there is not a number that meets the
> specified conditions. I've tried adding ISERROR in front of it and
> various other places, but I haven't been able to get it to
> work....perhaps I'm putting it in the wrong place or missing something
> that should go with it. Any help is appreciated! Thanks!
>
> =(INDEX($Q$2:$Q$2000,MATCH(1,(4=$L$2:$L$2000)*(100%=$M$2:$M$2000)*("Public
> Opinion"=$J$2:$J$2000)*("x"=$R$2:$R$2000),0)))
>
> --
> shikamikamoomoo
> ------------------------------------------------------------------------
> shikamikamoomoo's Profile: http://www.excelforum.com/member.php...o&userid=21018
> View this thread: http://www.excelforum.com/showthread...hreadid=525491

--

Dave Peterson

Thanks, got it to work!