Excel VLOOKUP between two sheets failing

Question

I'm attempting to duplicate data from sheet 1's column E, "Cost," so that sheet 2's column A, "Code," matches column A, "Code," on 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 tried using a VLOOKUP, but it's not working. Please help. Am I using Vlookup correctly?

I am bringing down this formula to sheet 2's column D.

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

Answer 1

Try this:

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

I altered "1"! $A$2:$A$811 to '1'! The table range you're using VLOOKUP on should contain both the column containing the lookup value and the column containing the result you desire to extract. $A$2:$E$811 In addition, I told VLOOKUP to use its last input, 0, to search for precise matches.

UPD:

As follows up from comments, the next formula works for OP:

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