title: Excel VLOOKUP between two sheets failing
body: <p>I am trying to copy data from column E (cost) in sheet1 where the value in column A (code) in sheet2 matches to the value in column A (code) on sheet1.</p>
  
  <pre><code>1
  +--------+--------+---------------+---------+--------+
  | A      | B      | C             | D       | E      |
  +--------+--------+---------------+---------+--------+
  | Code   | Name   | Description   | Price   | Cost   |
  +--------+--------+---------------+---------+--------+
  | AC33   | Prod 1 | Prod Desc 1   |  3.99   | 2.00   |
  +--------+--------+---------------+---------+--------+
  | AC34   | Prod 2 | Prod Desc 2   |  4.99   | 3.00   |
  +--------+--------+---------------+---------+--------+
  | AC35   | Prod 3 | Prod Desc 3   |  5.99   | 4.00   |
  +--------+--------+---------------+---------+--------+
  
  2
  
  +--------+--------+---------------+---------+
  | A      | B      | C             | D       |
  +--------+--------+---------------+---------+
  | Code   | Name   |Updated Price  | Cost    |
  +--------+--------+---------------+---------+
  | AC33   | Prod 1 |    16.99      |         | 
  +--------+--------+---------------+---------+
  | AC37   | Prod 2 |    18.99      |         |
  +--------+--------+---------------+---------+
  | AC38   | Prod 3 |    21.99      |         | 
  +--------+--------+---------------+---------+
  </code></pre>
  
  <p>I have used a VLOOKUP but it isn't working, can anyone help please? Am I right in using Vlookup?</p>
  
  <p>This is the formula I am dragging down in column D of sheet2</p>
  
  <p>=VLOOKUP(A2,'1'!$A$2:$A$811,5)</p>