title: Search and compare two columns in excel
body: <p>i have to columns in excel.</p>
  
  <pre><code>a      d
  b      f
  c      c
  d      e
  x
  y
  z
  e
  </code></pre>
  
  <p>the secong list is a subset of first list.</p>
  
  <p>i want to search the 1st list for the valus present in the 2nd and put it in 3rd column  like</p>
  
  <pre><code>a      d   present
  b      f   absent
  c      c   present
  d      e   present
  x
  y
  z
  e
  </code></pre>