Data merging with 2 worksheets

[markmerid]

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

 

[Sheeloo]

Use VLOOKUP... in A1 of Sheet1
=VLOOKUP(A1,Sheet2!A,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 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 #.

 

[Shane Devenshire]

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.