FORMULA
 

I have a hodge-podge list of numbers and letter-number combinations. I need
excel to tell me when any of those values appear in collumns J-N . can this
be done and how?

FORMULA
 

Where do you want an answer. Here or worksheet functions. In the future,
please do NOT post in more than one group as most of us who help read them
all.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"attyshane" wrote in message
...
I have a hodge-podge list of numbers and letter-number combinations. I
need
excel to tell me when any of those values appear in collumns J-N . can
this
be done and how?

FORMULA
 

this might work...assuming your list starts in column a2...

=IF((SUMPRODUCT(--($J$2:$J$65536=A2))+SUMPRODUCT(--($K$2:$K$65536=A2))+SUMPRODUCT(--($L$2:$L$65536=A2))+SUMPRODUCT(--($M$2:$M$65536=A2))+SUMPRODUCT(--($N$2:$N$65536=A2)))0,"Yes","No")

"attyshane" wrote:

I have a hodge-podge list of numbers and letter-number combinations. I need
excel to tell me when any of those values appear in collumns J-N . can this
be done and how?