Compare and match [Closed]

Report
-
mubashir aziz
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
Hello,

I have two work books and i have to match the information from on row a1 and move the information from A2 to work book 1

Book one Book two
A1 A1 A2
money money $100.00
blue blue $50.00
red red $25.00



I need to move A2 from wook book two to work book one to colum A2

How can I acomplish this task? please help. The info in the work books are over 3000 to move manully it will take hours

5 replies

can't you just copy the whole column and paste it in the other work book? To scroll to the bottom you can click on the first cell and then press control shift down arrow. Copy and paste are in the edit drop window.
Posts
2
Registration date
Sunday June 28, 2009
Status
Member
Last seen
July 2, 2009

No cause the work books contain other info that needs to staty the same. the info is sorted diffrent in one book and diffrent on the other, yet i would like to locate the same such all the names in a A1:A3000 and if found move the date of birth and copy it in a in A2:3000 only if the name is found, similar but the the same.
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
210
It can be easily done by using Vlookup or index/match .... it depends how the data you have ...... can you be more specific by giving exactly the column of work book 1 and 2 and explain which column you want to match ..... Try to write column heading using code<> button in reply window ...




Posts
2
Registration date
Sunday June 28, 2009
Status
Member
Last seen
July 2, 2009

Book 1
Column A - names
Column B - Accts #
 Column C- DOB
Column D- Balance


Book 2
Column A - names
Column B - Accts #
 Column C- Balance 
Column D- Adjustments
 Column E- tel #


First of all thank you for your help,

Both work books have similar information, I want to create only one but by moving the information to work book 1.

I want to move Column D and Column E from work book 2 to work book 1. by matching the Column B on both work books. Once the account # is located the adj and the tel information need to be move to column E and F.
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
210
if you have the same arrangement of columns in work books and also in sheet1 then use below formula

workbook1:sheet1
E2=INDEX([Book2.xls]Sheet1!$D:$D,MATCH(A2,[Book2.xls]Sheet1!$A:$A,0)) for adjustment from book 2
F2=INDEX([Book2.xls]Sheet1!$E:$E,MATCH(A2,[Book2.xls]Sheet1!$A:$A,0)) for tel # from book 2

you can use vlookup

E2=VLOOKUP(A2,[Book2.xls]Sheet1!$A$2:$E$41,4,FALSE)
F2==VLOOKUP(A2,[Book2.xls]Sheet1!$A$2:$E$41,5,FALSE)

Both work well but i preferred to use index/match ....

But one thing keep in your mind that names should be unique as if there will be same name then first name entry will always come from book2 .... hope there will be less equal name peoples there. but if there are then you can give them name- and name-2 in both work books ....