software

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)*(quot;Public
Opinionquot;=$J$2:$J$2000)*(quot;xquot;=$R$2:$R$2000),0)))--
shikamikamoomoo
------------------------------------------------------------------------
shikamikamoomoo's Profile: www.excelforum.com/member.php...oamp;userid=21018
View this thread: www.excelforum.com/showthread...hreadid=525491Too 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

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

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

Still array entered.

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

--

Dave Peterson


Thanks, got it to work!--
shikamikamoomoo
------------------------------------------------------------------------
shikamikamoomoo's Profile: www.excelforum.com/member.php...oamp;userid=21018
View this thread: www.excelforum.com/showthread...hreadid=525491