Here is what I need: A formula to get me the minimun value from a vlookup. What would the formula be under "earliest run date"

Thanks in advance!


Production Schedule Example

Line part run-date
1 A 7/1/2007
1 B 7/2/2007
1 C 7/3/2007
1 D 7/4/2007

2 B 7/1/2007
2 D 7/2/2007
2 C 7/3/2007
2 A 7/4/2007

3 C 7/1/2007
3 B 7/2/2007
3 D 7/3/2007
3 A 7/4/2007


earliest run-date
A 7/1/2007
B 7/2/2007
C 7/3/2007
D 7/4/2007