What determines "how long an individual has been on the account"? You need to
define that before a solution can be found.

My bet is the solution would be something along the lines of:

1. Combine the two worksheets
2. Use Sumproduct to, for example, determine the earliest start date and the
latest end date.

--
Regards,
Fred


"Sue" wrote in message
...
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