Combining 2 workbooks

  • Thread starter Thread starter Kayth
  • Start date Start date
K

Kayth

Hi,

I'm hoping someone can help me with this problem. I would
like to know if it is possible to have 2 separate
workbooks and generate a list with information from both
work books. Each workbook has one column in common.
Example: Workbook 1 has the person's name and their
corresponding account#. Workbook 2 has their addresses
with their corresponding account#. Can I generate a new
list that takes the names from workbook 1 and combines it
with the addresses from workbook 2 using the account
number found in both workbooks? If so how do I do it?
Please keep in mind that I have just basic knowledge of
Excel. I contacted Microsoft and I was told that this
can be done in Excel. I appreciate any help.

Thanks for your help.
Kayth
 
Hi
if you want to add for example the names of workbook 1 to the list in
workbook two try the following formula:
=VLOOKUP(A1,'[workbook1.xls]Sheet1'!$A$1:$B$1000,2,0)
this copies the data from column B to the list in workbook 2
copy this formula down for all rows.

assumptions:
- both lists are on sheet1 of each workbook
- column A contains the account# in both lists

Also take a look at: http://www.mvps.org/dmcritchie/excel/vlookup.htm
 
If WB1 has the names in column A, and the account numbers in column B, you
could add a formula to column C, which would pull the address from WB2.
If WB2 had the account number in column A, and the address in columnB, try
this formula, starting in C2 of WB1:

=INDEX([WorkBook2.xls]Sheet1!$B$2:$B$25,MATCH(B2,[WorkBook2.xls]Sheet1!$A$2:
$A$25,0))

And drag down to copy as needed.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



Hi,

I'm hoping someone can help me with this problem. I would
like to know if it is possible to have 2 separate
workbooks and generate a list with information from both
work books. Each workbook has one column in common.
Example: Workbook 1 has the person's name and their
corresponding account#. Workbook 2 has their addresses
with their corresponding account#. Can I generate a new
list that takes the names from workbook 1 and combines it
with the addresses from workbook 2 using the account
number found in both workbooks? If so how do I do it?
Please keep in mind that I have just basic knowledge of
Excel. I contacted Microsoft and I was told that this
can be done in Excel. I appreciate any help.

Thanks for your help.
Kayth
 
Back
Top