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.