FORMULA

  • Thread starter Thread starter attyshane
  • Start date Start date
A

attyshane

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?
 
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.
 
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")
 
Back
Top