Vlookup returning errors

[Buzzby]

I want to check the post codes from both new data and data and return ref in column A sheet 2. At the moment all I get are errors?

Example would be D3 "new data" is a match with D3 "data" should return 10562 in A3 "new data".

Sent example sheet to help.

[ChemistB]

Let's examine your formula;
=VLOOKUP(D2,data!D2:D7,7,FALSE)
D2 is what you want to look up, in
data!D2:D7 (data array)
and (after finding a match)returning the result from column 7 of your array.
"False" means return only exact matches

First of all, your array is set to a single column (D) and you ask Excel to return the results from Column 7. If you want to return Ref from Column G, your data array should be D2:G7 and return column 4.

Also, lock your array reference in place with $. Otherwise when you drag or copy your formula, the reference will change. ie in A6, you have =VLOOKUP(D6,data!D6:D11,7,FALSE) which is now looking in D6:D11 instead of D2:D7.

So your new formula in A2 should be
=VLOOKUP(D2,data!$D$2:$G$7,4,FALSE)

Does this help?