Lookup Functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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?
 
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.
 
Back
Top