MS Excel Worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have multiple worksheets with at least one common field. I need to create
an additional worksheet that combines the related fields based on the field
that is common to all. Which function does this?
Thank you.
 
What do you mean by "combines the related fields"?

If you mean "sums" then you can use

=SUM(Sheet1:Sheet5!A1)


where Sheet1 is the left-most sheet and Sheet5 is the right-most sheet
that you want to sum.
 
It sounds like you need the =VLOOKUP worksheet function, possibly nested in
an =ISNA function. Check out the Excel Help on these.
 
You must log in or register to reply here.

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

combine rows with similar data, but different fields in excel 1
Merging two worksheets that have a common field 4
Matching records based on a common field 1
how do i combine excel worksheets 1
VLookup Function over Multiple Worksheets 3
Setting Scope of name ranges to particular worksheet 2
Finding duplicates within several worksheets 2
Need to merge worksheets - Excel 2003 0

Back
Top