You can try also the Consolidate (Data-consolidate)

"Exseller" a scris:

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