Sue,
The question is how you would know that the two records are linked - Id
appears multiple times which makes it difficult.
I guess Id needs to be the same, what else?


"Sue" wrote:

Hi.. I need help desparately. I have two individual workbooks. Workbook A
contains, application, home country, Id, etc., information and Workbook B
contains id, home country, start date, end date, etc. In both workbooks the
Id may appear multiple times.

In order to determine how long an individual has been on the account and
worked on a specific application, I need to be able to tie the data in one
workbook to that in the other workbook.

How can I perform this task and what type of formula (vlookup or other)
would I need?

Thank you in advance for your help.

Sue