Hi,

I'll describe my problem using a simple example.

I have two sheets.
Sheet 1 contains records (rows) with identifiers X1,X2,X3,X4,X5
(in column K0) and other data in columns K1,K2,K3,K4.
Sheet 2 contains records (rows) with identifiers X2,X4,X5
(in column K0) and other data in columns K5,K6,K7.
All identifiers which are in Sheet 2 are in Sheet 1.
I want to have a Sheet 3 (or updated Sheet 1)
containing records (rows) with identifiers X1,X2,X3,X4,X5
(in column K0) and columns K1,K2,K3,K4,K5,K6,K7
where data in columns K1,K2,K3,K4 are from Sheet1
and data in columns K5,K6,K7 are from Sheet 2.
It seems to be a kind of combining two sheets.
How to do it?
In real example there are hundreds of records.
Please help me. It is urgent.

Regards

Your column and row references are unfamiliar to me, so you will have to
convert:

If there are hundreds of records of each identifier on Sheet 1, and
similarly multiple records of each identifier on Sheet 2, what rule do you
use to "match" up the records.

IF, Sheet 2 is actually a reference of data, having 1 unique record for each
identifier, you can use a vlookup table and function. But again, this would
only work is Sheet 2 is for reference. Otherwise I have no idea of what
method you want to match up the two sheets.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"KaZetE" wrote:

Hi,

I'll describe my problem using a simple example.

I have two sheets.
Sheet 1 contains records (rows) with identifiers X1,X2,X3,X4,X5
(in column K0) and other data in columns K1,K2,K3,K4.
Sheet 2 contains records (rows) with identifiers X2,X4,X5
(in column K0) and other data in columns K5,K6,K7.
All identifiers which are in Sheet 2 are in Sheet 1.
I want to have a Sheet 3 (or updated Sheet 1)
containing records (rows) with identifiers X1,X2,X3,X4,X5
(in column K0) and columns K1,K2,K3,K4,K5,K6,K7
where data in columns K1,K2,K3,K4 are from Sheet1
and data in columns K5,K6,K7 are from Sheet 2.
It seems to be a kind of combining two sheets.
How to do it?
In real example there are hundreds of records.
Please help me. It is urgent.

Regards

Thank you for your reply.

If there are hundreds of records of each identifier on Sheet 1,
I didn't say that there were hundred of records of each identifier.
Not at all. There is only one record of each identifier on Sheet1
and only one record of each identifier on Sheet 2.
On Sheet 1 there are all records (=all identifiers) whereas on
Sheet 2 there are only some of them with different columns than
on Sheet 2.

Regards


"Luke M" :

Your column and row references are unfamiliar to me, so you will have to
convert:

If there are hundreds of records of each identifier on Sheet 1, and
similarly multiple records of each identifier on Sheet 2, what rule do you
use to "match" up the records.

IF, Sheet 2 is actually a reference of data, having 1 unique record for each
identifier, you can use a vlookup table and function. But again, this would
only work is Sheet 2 is for reference. Otherwise I have no idea of what
method you want to match up the two sheets.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"KaZetE" wrote:

Hi,

I'll describe my problem using a simple example.

I have two sheets.
Sheet 1 contains records (rows) with identifiers X1,X2,X3,X4,X5
(in column K0) and other data in columns K1,K2,K3,K4.
Sheet 2 contains records (rows) with identifiers X2,X4,X5
(in column K0) and other data in columns K5,K6,K7.
All identifiers which are in Sheet 2 are in Sheet 1.
I want to have a Sheet 3 (or updated Sheet 1)
containing records (rows) with identifiers X1,X2,X3,X4,X5
(in column K0) and columns K1,K2,K3,K4,K5,K6,K7
where data in columns K1,K2,K3,K4 are from Sheet1
and data in columns K5,K6,K7 are from Sheet 2.
It seems to be a kind of combining two sheets.
How to do it?
In real example there are hundreds of records.
Please help me. It is urgent.

Regards

If there are hundreds of records of each identifier on Sheet 1,
I didn't say that there were hundred of records of each identifier.
Not at all. There is only one record of each identifier on Sheet1
and only one record of each identifier on Sheet 2.
On Sheet 1 there are all records (=all identifiers) whereas on
Sheet 2 there are only some of them with different columns than
on Sheet 2.

On Sheet 1 there are all records (=all identifiers) whereas on
Sheet 2 there are only some of them with different columns than
on Sheet 2.
on Sheet 1, of course. Sorry.

Regards