View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ryanholliday ryanholliday is offline
external usenet poster
 
Posts: 3
Default 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