Hi, I have a main list of 200 entries. The headings are ID, Date, value. The ID and Date will be duplicated at various times, however the value will be different. E.g.
ID…..Date……Value
101…01/01/13…89
101…01/01/13…78
102…02/03/13…66
102…02/03/13…50
I was given a smaller unique list of IDs and Dates and was told to extract the related value from the main list for both the ID And Date. I tried a vlookup and also a concatenation of the ID and Date but it always duplicates the value. I get the following:
101...01/01/13...89
101...01/01/13...89
Is there a way to extract duplicate IDs and Dates and their relevant different values?
ID…..Date……Value
101…01/01/13…89
101…01/01/13…78
102…02/03/13…66
102…02/03/13…50
I was given a smaller unique list of IDs and Dates and was told to extract the related value from the main list for both the ID And Date. I tried a vlookup and also a concatenation of the ID and Date but it always duplicates the value. I get the following:
101...01/01/13...89
101...01/01/13...89
Is there a way to extract duplicate IDs and Dates and their relevant different values?