Use VLOOKUP... in A1 of Sheet1
=VLOOKUP(A1,Sheet2!A:D,2,FALSE)
will try to find A1 of Sheet1 in Col A of Sheet2... if found it will go to
Col B (because of 2...) and get the value from there.... If you have 3 it
will pick from Col C....

If you want to go beyound Col D then extend
Sheet2!A:D to Sheet2!A:Z or whatever you want and pick the index
(2,3,4,...25) of the column you want...

In your case Col A would be reference #.

"markmerid" wrote:

hi,

I have 2 versions of a worksheet - both are very similar and have the same
amount of records but there is a chunk of data in one column missing in one
of the sheets. The worksheets hold about 9000 records and there is a data set
of about 1800 where they have info missing.

I need to get the data from the populated column in one worksheet into the
other. Each record has a unique reference number. Does any one of the best
way to do this?

Thanks