Combination of data out to two worksheets

[Exseller]

I have extensive data on two worksheets that should be combined to one sheet.
Is there a function in excel that allows me do this?
The relation between the two sheets could be the name or the name id.

Example:
In one sheet i have for example name and salary data.
In the other i have name, function and job level.
I would like to create a third sheet with name, salary, function and job level.

PS. The number of items and the order of entry are not the same on both worksheets.

Thanks in advance
Reto

 

[Shetty]

If each entry (name as in your example) are unique, you can use VLOOKUP
to fatch data from the other sheet. Just enter in a cell and dreg down
to the last cell. If an item is not found, vlookup will return error
N/A.
Regards,
Shetty

 

[Shetty]

If each entry (name as in your example) are unique, you can use VLOOKUP
to fatch data from the other sheet. Just enter in a cell and dreg down
to the last cell. If an item is not found, vlookup will return error
N/A.
Regards,
Shetty

 

[Shetty]

If each entry (name as in your example) are unique, you can use VLOOKUP
to fatch data from the other sheet. Just enter in a cell and dreg down
to the last cell. If an item is not found, vlookup will return error
N/A.
Regards,
Shetty

 

[Guest]

You can try also the Consolidate (Data-consolidate)

"Exseller" a scris:

 

[Tom Ogilvy]

That really is for summarizing numeric data, isn't it?