Example worksheets:
I'm trying to resolve for Worksheet1 B2 - B4
I want to find the earliest transaction date in Worksheet2 for each UniqueID in Worksheet1 Column A and place the date in Worksheet1 Column B.
There are only unique ID numbers in A Worksheet 1
Worksheet2 is a transaction table so there are multiple records with the same ID.
I have tried using the VLOOKUP(MIN but am missing something because it just does not work.
I would prefer a function solution vs VBA, if possible.
<tbody>
</tbody>
Worksheet1
<tbody>
</tbody>
Worksheet2
Thanks,
I'm trying to resolve for Worksheet1 B2 - B4
I want to find the earliest transaction date in Worksheet2 for each UniqueID in Worksheet1 Column A and place the date in Worksheet1 Column B.
There are only unique ID numbers in A Worksheet 1
Worksheet2 is a transaction table so there are multiple records with the same ID.
I have tried using the VLOOKUP(MIN but am missing something because it just does not work.
I would prefer a function solution vs VBA, if possible.
A | B | |
1 | UniqueID | ActualStartDate |
2 | A123 | |
3 | A124 | |
4 | A125 |
<tbody>
</tbody>
Worksheet1
A | B | |
1 | UniqueID | TransDate |
2 | A123 | 1/13/16 |
3 | A123 | 2/1/16 |
4 | A124 | 12/13/16 |
5 | A123 | 9/22/16 |
6 | A124 | 10/13/16 |
7 | A123 | 7/25/16 |
8 | A125 | 8/1/16 |
<tbody>
</tbody>
Worksheet2
Thanks,