How do I merge info. from 2 sheets using common numbers in Excel?

A

Angela

I am trying to merge information from two different sheets. Both sheets share
a common item #. How can I get the information all together on one sheet
using that one common item # as the link? Help...
 
B

bj

If the number only shows up once in each sheet and the information you want
to group is on one row,Vlookup() will probably do what you want, but without
more details we can't be sure.
if the grouping are more complex, or has multile rows on information, the
method can get more complex, but shouod be doable.
 

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.

Ask a Question

Similar Threads

Page numbering with Merged Document and IF statements 1
Merging from an Excel file with graphics 1
Integrating information from Word to Excel (not mail merge) 1
Mail Merge skipping records/sending one at a time 0
In Excel 07, how do I merge two sprdshts with a common column? 1
Trying to create custom labels from an csv file + Need items numerically counted out 0
How do i compare and remove common names from 2 excel work sheets 0
Duplicate Mail Merge Record Every Time 5

Top