title: Lookup in other tab of excel sheet
body: <p>I have excel sheet having two tabs in it, A and B</p>
  
  <pre><code>In A excel tab the columns are ID, Price/Unit
  In B excel tab the coulmns are ID, NumberOfSoldUnits
  </code></pre>
  
  <p>I want to get NumberOfSoldUnits in Column C in tab A excel on the basis of matching ID. How can achieve this using VLOOKUP ?</p>
  
  <pre><code>I have tried this : =VLOOKUP(A,B!A:B,2,0)
  </code></pre>
  
  <p>But giving error 508</p>