Excel VLOOKUP between two sheets

Question

I am trying to copy data from column E (cost) to sheet1, where the value in column A (code) in sheet2 corresponds to the value in column A (code) in sheet 1.

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      |         | 
+--------+--------+---------------+---------+

I used VLOOKUP but it does not work, can anyone help? Am I using Vlookup correctly?

This is the formula I drag in column D of sheet2

= VLOOKUP (A2, '1' $ A $ 2: $ A $ 811.5)

Answer 1

Try the following:

=VLOOKUP(A2,'1'!$A$2:$E$811,5,0)

'1'!$A$2:$A$811 '1'!$A$2:$E$811 ( @Jerry , " , VLOOKUP on, , , , " ), VLOOKUP 0, VLOOKUP, .

UPD:

, OP:

=VLOOKUP(TRIM(A2),'1'!$A$2:$E$811,5,0)