Hey! That seems to work. Thanks!

"Ron Coderre" wrote:

Try something like this:

With your posted data in A1:B5

C1: =(COUNTIF($A$1:$A$5,B1)0)
copy that formula down through C5

or...if you want to search the entire column
=(COUNTIF(A:A,B1)0)


Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Ken" wrote:

I need a formula that will detect the presence of a value in an unsorted
named array.

Column A would be the named array.
Column B would be the value I want to test for.
Column C would be the formula.

So, this is sort of what it would look like. "D" is the only value that
would return a True because it is the only value present in the named array.

D I False
B O False
W D True
T A False
J P False

Anyone know how to do this?