I was just acknowledging that I made a mistake,
Sorry,
"Rick Rothstein (MVP - VB)" wrote in
message ...
Am I missing something... isn't that what he posted?

Rick


"Alan" wrote in message
...
That's good, but what David said is correct, it can be shortened to
=COUNTIF(B1:B50,A1)0
Regards,
Aln.

"jfrick" wrote in message
...
Alan:

Thanks this works great. Thanks everyone for your suggestions.

Josh

"Alan" wrote:

With the cell to test in A1 and the range to test if it matches in
B1:B50,
=IF(COUNTIF(B1:B50,A1)0,TRUE,FALSE)
Regards,
Aln.
"jfrick" wrote in message
...
I am trying to write a formula that tests a cell value to see if it
matches
values in a range of values and returns either true or false. Any
help
would be greatly appreciated.

Josh