title: How to find common values in excel using vlookup
body: <p>I am trying to find out the common values in excel, I have four different columns in excel . ColumnB , ColumnG , ColumnM and ColumnQ , I am applying vlookup to extract the common values in these four columns</p>
  
  <pre><code>=VLOOKUP(B4,$B$4:$Q$33,1,FALSE)
  </code></pre>
  
  <p><strong>I have total of 33 rows in all the four columns , by applying the vlookup i am not getting the correct answer, Any help would be appreciated.</strong></p>
  
  <p>Sample Data</p>
  
  <p><a href="https://i.stack.imgur.com/kBmYd.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/kBmYd.png" alt="enter image description here"></a></p>
  
  <p>Required output will be A</p>