Compare and match
Closed
sassy
-
Jun 29, 2009 at 10:43 AM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Jul 2, 2009 at 10:53 PM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Jul 2, 2009 at 10:53 PM
Related:
- Compare and match
- Music match jukebox - Download - Audio playback
- Beyond compare - Download - File management
- Excel compare two sheets - Guide
- Position of mouse pointer does not match screen coordinates clicked - Guide
- Royal match pc - Download - Puzzle
5 responses
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.
sasy v
Posts
2
Registration date
Sunday June 28, 2009
Status
Member
Last seen
July 2, 2009
Jun 29, 2009 at 03:37 PM
Jun 29, 2009 at 03:37 PM
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.
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
166
Jul 2, 2009 at 01:48 AM
Jul 2, 2009 at 01:48 AM
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 ...
sasy v
Posts
2
Registration date
Sunday June 28, 2009
Status
Member
Last seen
July 2, 2009
Jul 2, 2009 at 08:51 AM
Jul 2, 2009 at 08:51 AM
Book 1
Column A - namesColumn B - Accts # Column C- DOBColumn D- Balance
Book 2
Column A - namesColumn 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.
Column A - namesColumn B - Accts # Column C- DOBColumn D- Balance
Book 2
Column A - namesColumn 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.
Didn't find the answer you are looking for?
Ask a question
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
166
Jul 2, 2009 at 10:53 PM
Jul 2, 2009 at 10:53 PM
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 ....
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 ....