title: Excel:comparing two columns and return matched value in a single cell
body: <p>I'm trying to match two columns and get the matched value in a single cell.
  For eg.</p>
  <blockquote>
  <p>Column 1 - 8, 5, 7, AA, 10</p>
  <p>Column2  - AA, DET, V, H, PED</p>
  </blockquote>
  <pre><code>8    AA
  5    DET
  7    V
  AA   H
  10   PED
  </code></pre>
  <p>Value returned - AA (This is the value that i want to get since this is common in both columns)</p>
  <p>I tried using Index and match functions, but they are not able to match the two given range. Please help. Thanks in advance.</p>