MS Excel Worksheets
 

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.

In article ,
"Wordgeek" wrote:

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?

It sounds like you need the =VLOOKUP worksheet function, possibly nested in
an =ISNA function. Check out the Excel Help on these.

"Wordgeek" wrote in message
...
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.