Simple lookup question
 

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

Simple lookup question
 

Try

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

--
Jacob (MVP - Excel)


"ryanholliday" wrote:

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