Lookup array?
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" wrote in message
...
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
|