Compare and Extract
 

Hi All,

I have a problem cmparing and extract data from 2 workbooks. The two
workbooks have only the item code in common. eg;

WorkBook1

A B C
1 ITEMCODE DES QTY
2 001 Pen 3
3 002 Book 4
4 B003 Notepad 4

WorkBook2

A B C
1 ITEMCODE SUPCODE PRICE
2 001 LOO1 $5
3 002 B4520 $1
4 B003 N0001 $4

As you can see only the item code is the same but all the information points
to the same information. Is it possible to firstly compare the information
and then extact data to different workbook.eg

WorkBook3

A B C D
1 ITEMCODE DES QTY PRICE
2 001 Pen 3 $5
3 002 Book 4 $1
4 B003 Notepad 4 $4

If anyone can help please do, thank alot all

--
Message posted via http://www.officekb.com

Compare and Extract
 

Enter in workbook3 A1
=[workbook1.xls]Sheet1!A1
and drag it to the right to C1 and down as required

Enter in workbook3 D1
=[workbook2.xls]Sheet1!$C1
and drag it down as required

It works only if the order of workbook1.xls and workbook2.xls is the same
like in the example!

Regards,
Stefi


€žNaba via OfficeKB.com€� ezt Ã*rta:

Hi All,

I have a problem cmparing and extract data from 2 workbooks. The two
workbooks have only the item code in common. eg;

WorkBook1

A B C
1 ITEMCODE DES QTY
2 001 Pen 3
3 002 Book 4
4 B003 Notepad 4

WorkBook2

A B C
1 ITEMCODE SUPCODE PRICE
2 001 LOO1 $5
3 002 B4520 $1
4 B003 N0001 $4

As you can see only the item code is the same but all the information points
to the same information. Is it possible to firstly compare the information
and then extact data to different workbook.eg

WorkBook3

A B C D
1 ITEMCODE DES QTY PRICE
2 001 Pen 3 $5
3 002 Book 4 $1
4 B003 Notepad 4 $4

If anyone can help please do, thank alot all

--
Message posted via http://www.officekb.com

Compare and Extract
 

Well, if the order of source workbooks is different, then
enter in workbook3 D2
=VLOOKUP(A2,[workbook2.xls]Sheet1!$A:$C,3,FALSE)
and drag it down as required

Regards,
Stefi

€žStefi€� ezt Ã*rta:

Enter in workbook3 A1
=[workbook1.xls]Sheet1!A1
and drag it to the right to C1 and down as required

Enter in workbook3 D1
=[workbook2.xls]Sheet1!$C1
and drag it down as required

It works only if the order of workbook1.xls and workbook2.xls is the same
like in the example!

Regards,
Stefi


€žNaba via OfficeKB.com€� ezt Ã*rta:

Hi All,

I have a problem cmparing and extract data from 2 workbooks. The two
workbooks have only the item code in common. eg;

WorkBook1

A B C
1 ITEMCODE DES QTY
2 001 Pen 3
3 002 Book 4
4 B003 Notepad 4

WorkBook2

A B C
1 ITEMCODE SUPCODE PRICE
2 001 LOO1 $5
3 002 B4520 $1
4 B003 N0001 $4

As you can see only the item code is the same but all the information points
to the same information. Is it possible to firstly compare the information
and then extact data to different workbook.eg

WorkBook3

A B C D
1 ITEMCODE DES QTY PRICE
2 001 Pen 3 $5
3 002 Book 4 $1
4 B003 Notepad 4 $4

If anyone can help please do, thank alot all

--
Message posted via http://www.officekb.com