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?
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
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.