Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating GIFs in Excel 2003 for use in Dreamweaver | Charts and Charting in Excel | |||
Linking to Worksheets on Excel -Saved Web Page | Links and Linking in Excel | |||
Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel | |||
Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) | |||
No Smart Tag help: just a blank "MS Excel Help" window - Excel 2003 | Excel Discussion (Misc queries) |