Simple lookup question

[ryanholliday]

I have a value in A1. I want to look in columns B:K to see if the value in
A1 exists anywhere in those columns (regardless of row). Just a simple "yes"
or "no" would suffice to tell me whether the A1 value exists anywhere in
columns B:K.

Thanks much,
Ryan

 

[Jacob Skaria]

Try

=IF(COUNTIF(B:K,A1),"Yes","No")