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

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

Lookup array?
 

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

hbj

"Bob Phillips" wrote in message
...
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