Excel

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

Kayth

Hello,
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 work book 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
report with the person name and address from the 2
workbooks, and how do I do it? Please keep in mind that I
have just basic knowledge of Excel.
Thanks for your help.
Kayth
 
Use the VLOOKUP function (look in HELP index)
=VLOOKUP(C5,[yourworkbook.xls]Sheet3!$A$1:$D$7,2,FALSE)
where c5 contains the account number and the table is in
yourworkbook,sheet2,a1:d7
 
Hi,

I've tried the vlookup as was suggested but I was only
able to look up only 1 account number with the address.
I was hoping to create a new list with both workbooks.
I'm not sure what I did wrong. I would appreciate any
help.

Thank you,
Kayth
-----Original Message-----
Use the VLOOKUP function (look in HELP index)
=VLOOKUP(C5,[yourworkbook.xls]Sheet3!$A$1:$D$7,2,FALSE)
where c5 contains the account number and the table is in
yourworkbook,sheet2,a1:d7
--
Don Guillett
SalesAid Software
(e-mail address removed)
Kayth said:
Hello,
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 work book 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
report with the person name and address from the 2
workbooks, and how do I do it? Please keep in mind that I
have just basic knowledge of Excel.
Thanks for your help.
Kayth
Click to expand...


.
Click to expand...
 
Kayth

Have you tried dragging the formula down through multiple cells in the column.

The C5 will change to C6, C7, C8 etc. The rest will remain the same.

Gord Dibben Excel MVP

Hi,

I've tried the vlookup as was suggested but I was only
able to look up only 1 account number with the address.
I was hoping to create a new list with both workbooks.
I'm not sure what I did wrong. I would appreciate any
help.

Thank you,
Kayth
-----Original Message-----
Use the VLOOKUP function (look in HELP index)
=VLOOKUP(C5,[yourworkbook.xls]Sheet3!$A$1:$D$7,2,FALSE)
where c5 contains the account number and the table is in
yourworkbook,sheet2,a1:d7
--
Don Guillett
SalesAid Software
(e-mail address removed)
Kayth said:
Hello,
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 work book 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
report with the person name and address from the 2
workbooks, and how do I do it? Please keep in mind that I
have just basic knowledge of Excel.
Thanks for your help.
Kayth
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top