Min Value using array ignores Zero

Im trying to search a two column list using the following formula. Its an array formula which I know not very much about....

{=MIN(IF((Sheet2!$F$3:$F$3500=E3)*(Sheet2!$J$3:$J$3500),(Sheet2!$J$3:$J$3500)))}

Its working almost perfectly. The only problem Im having is if the values are, for example:

10
2
5
100
12
0

It will pick the 2 not the Zero.

I need to be able to pick the Zero in cases such as this. Does anyone have hints on a tweak to the formula?

Gavin

=MIN(IF((Sheet2!$F$3:$F$10=E3)*(Sheet2!$J$3:$J$10>=0),(Sheet2!$J$3:$J$10)))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mauddib" <mauddib.1kk806@excelforum-nospam.com> wrote in message
news:mauddib.1kk806@excelforum-nospam.com...
>
> Im trying to search a two column list using the following formula. Its
> an array formula which I know not very much about....
>
>
{=MIN(IF((Sheet2!$F$3:$F$3500=E3)*(Sheet2!$J$3:$J$3500),(Sheet2!$J$3:$J$3500
)))}
>
> Its working almost perfectly. The only problem Im having is if the
> values are, for example:
>
> 10
> 2
> 5
> 100
> 12
> 0
>
> It will pick the 2 not the Zero.
>
> I need to be able to pick the Zero in cases such as this. Does anyone
> have hints on a tweak to the formula?
>
> Gavin
>
>
> --
> mauddib
> ------------------------------------------------------------------------
> mauddib's Profile:
http://www.excelforum.com/member.php...fo&userid=4169
> View this thread: http://www.excelforum.com/showthread...hreadid=346025
>

or even

=MIN(IF((Sheet2!$F$3:$F$10=E3),(Sheet2!$J$3:$J$10)))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:%23lURjlFFFHA.2460@TK2MSFTNGP09.phx.gbl...
>
=MIN(IF((Sheet2!$F$3:$F$10=E3)*(Sheet2!$J$3:$J$10>=0),(Sheet2!$J$3:$J$10)))
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "mauddib" <mauddib.1kk806@excelforum-nospam.com> wrote in message
> news:mauddib.1kk806@excelforum-nospam.com...
> >
> > Im trying to search a two column list using the following formula. Its
> > an array formula which I know not very much about....
> >
> >
>
{=MIN(IF((Sheet2!$F$3:$F$3500=E3)*(Sheet2!$J$3:$J$3500),(Sheet2!$J$3:$J$3500
> )))}
> >
> > Its working almost perfectly. The only problem Im having is if the
> > values are, for example:
> >
> > 10
> > 2
> > 5
> > 100
> > 12
> > 0
> >
> > It will pick the 2 not the Zero.
> >
> > I need to be able to pick the Zero in cases such as this. Does anyone
> > have hints on a tweak to the formula?
> >
> > Gavin
> >
> >
> > --
> > mauddib
> > ------------------------------------------------------------------------
> > mauddib's Profile:
> http://www.excelforum.com/member.php...fo&userid=4169
> > View this thread:
http://www.excelforum.com/showthread...hreadid=346025
> >
>
>