Lookup array?

Probably a peace of cake, but I can't work it out...

I have an array of values in the area A1 to B3.

I want to know if any cell in the array A1:B3 contains eg. value 5?

LOOKUP or INDEX or MATCH?

HBj

If you just want to know if it is in there

=COUNTIF(A1:B3,5)>0

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"HBj" <ky1488@hotmail.com.invalid> wrote in message
news:eCuKpIREGHA.2728@TK2MSFTNGP14.phx.gbl...
>
> Probably a peace of cake, but I can't work it out...
>
> I have an array of values in the area A1 to B3.
>
> I want to know if any cell in the array A1:B3 contains eg. value 5?
>
> LOOKUP or INDEX or MATCH?
>
> HBj
>
>

Thank you so much! I couldn't imagine it was _that_ simple....

hbj

"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:uulv5jREGHA.2040@TK2MSFTNGP14.phx.gbl...
> If you just want to know if it is in there
>
> =COUNTIF(A1:B3,5)>0
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "HBj" <ky1488@hotmail.com.invalid> wrote in message
> news:eCuKpIREGHA.2728@TK2MSFTNGP14.phx.gbl...
> >
> > Probably a peace of cake, but I can't work it out...
> >
> > I have an array of values in the area A1 to B3.
> >
> > I want to know if any cell in the array A1:B3 contains eg. value 5?
> >
> > LOOKUP or INDEX or MATCH?
> >
> > HBj
> >
> >
>
>