Finding a value

[kclong]

I have a table similar to the following:

A B C D
1 2 3 4
5 6 7 8
9 10 11 12
13 14 15 16

I simply want to know if, say, the number 6 is anywhere in the table. I don't need to know the reference point, just the fact that it's a part of the table. I've looked at vlookup, hlookup, lookup, match, index and I can't get any to work the way I want them to.

Note, I don't want to do this in the macro, just a command in the spreadsheet.

Any suggestions? Thanks as always.

 

[Jonmo1]

I don't need to know the reference point, just the fact that it's a part of the table

Try COUNTIF

=COUNTIF(A1:D4,6)>0

 

[kclong]

Perfect! Thanks.