software

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)gt;0

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;HBjquot; gt; wrote in message
...
gt;
gt; Probably a peace of cake, but I can't work it out...
gt;
gt; I have an array of values in the area A1 to B3.
gt;
gt; I want to know if any cell in the array A1:B3 contains eg. value 5?
gt;
gt; LOOKUP or INDEX or MATCH?
gt;
gt; HBj
gt;
gt;
Thank you so much! I couldn't imagine it was _that_ simple....

hbj

quot;Bob Phillipsquot; gt; wrote in message
...
gt; If you just want to know if it is in there
gt;
gt; =COUNTIF(A1:B3,5)gt;0
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;HBjquot; gt; wrote in message
gt; ...
gt; gt;
gt; gt; Probably a peace of cake, but I can't work it out...
gt; gt;
gt; gt; I have an array of values in the area A1 to B3.
gt; gt;
gt; gt; I want to know if any cell in the array A1:B3 contains eg. value 5?
gt; gt;
gt; gt; LOOKUP or INDEX or MATCH?
gt; gt;
gt; gt; HBj
gt; gt;
gt; gt;
gt;
gt;