MS Excel Worksheets

W

Wordgeek

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.
 
J

JE McGimpsey

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.
 
I

Ian Ripsher

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