Lookup array?

H

HBj

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
 
B

Bob Phillips

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)
 
Top