title: Excel how to find values in 1 column exist in the range of values in another
body: <p>I have two columns- column A which extends upto 11027(values) and column I which extends to 42000(values).Both the columns contains some code details.</p>
  
  <p>Something like this</p>
  
  <pre><code>A               B
  q123           as124
  as124          gh456
  ff45           q123
  dd1             dd2
  xx2
  xx3
  xx4
  </code></pre>
  
  <p>and so on...</p>
  
  <p>I want to find if the names in column A exists in column B or not.using excel</p>