Data merging with 2 worksheets
 

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

Data merging with 2 worksheets
 

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

Data merging with 2 worksheets
 

Hi,

Since you say 1800 of 9000 rows are missing data, part of your question may
be how do you enter Sheeloo's formula in only those rows without data? If
so, select the column which is missing some data and press F5, Special,
Blanks, OK.

Now type but don't enter a VLOOKUP formula and then press Ctrl+Enter.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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