ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   how do I merge a worksheet into another one? (https://www.excelbanter.com/new-users-excel/85741-how-do-i-merge-worksheet-into-another-one.html)

chelle38

how do I merge a worksheet into another one?
 
I have a worksheet that has information that I want to insert addresses in
from another worksheet, they share a common id number. How do I merge the
two?

pdberger

how do I merge a worksheet into another one?
 
C --
You want to use a VLOOKUP or HLOOKUP function -- they look up info from one
table and put it in the cell. The Excel help is pretty good on this, but it
can be a little tricky the first time. Try their help with very small tables
of info until you get the hang of it.

HTH

"chelle38" wrote:

I have a worksheet that has information that I want to insert addresses in
from another worksheet, they share a common id number. How do I merge the
two?



All times are GMT +1. The time now is 05:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com