VLOOKUP: Showing Data from a cell in Sheet 2 based on a cell in Sheet 1

Hello. All help appreciated in advance.

I have 2 worksheets.

Sheet 1 has information in 2 columns. Column 1 has Acct numbers, Col 2 has the postcode.

Sheet 2 has 2 columns also. Column 1 has Acct numbers, Col 2 has an email address.

I want to combine the 2 sets of data into Sheet 1 so that:

Col 1 has Acct Number, Col 2 has Postcode and Col 3 has email address.

The acct numbers across both worksheets are NOT sequential and some are missing, therefore a simple copy/paste isn't appropriate.

I have done a VLOOKUP in one cell which gives the correct result. However, filling down the column does not work for reasons I can't get my head around. I've hit F4 in lookup_value without any success.

Can anyone please advise? I appreciate I've probably not described it very well. Is it possible VLOOKUP isn't the right formula?

Thanks,

G.

Hi , GGPK
would you upload example file or show your formula ?
maybe should use absolute $ vlookup( value ,sheet2!a$2:a$200,2,0) ?

Thanks Careless.. I was missing a $ in the formula string. More $, more problems