Compare and Extract

  • Thread starter Thread starter Naba via OfficeKB.com
  • Start date Start date
N

Naba via OfficeKB.com

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
 
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:
 
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
Click to expand...
Click to expand...
 
Back
Top