Excel function required(urgent)

[sk5567]

I have a Excel sheet,which contains 2 sheets namely Sheet1 and Sheet2.

Sheet1 contains 2 columns namely activity code and Start Date.The data looks like this

Sheet1:

Activity code Date
P1 01/31/2003
P2 03/31/2003
p1 12/31/2002
p2 04/01/2003

In sheet1 The activity code repeats.

Sheet2 also contains the same 2 columns.The data will be like this

Activity code Date
P1
P2

Now my requirement is For P1 in 2nd sheet I have to get the min date for P1 from first sheet .ie, For p1 I have to goto sheet1 and check all the dates for P1 and get minimum date for p1.

The value will be 12/31/2002.

How to do this?? Any function or we need to write a macro?? I don't know VBA programming.Please help

Thanks
sk5567

[alex_read]

2 formulas you can write in a single statement in the formula bar (without the need for vba) would be @VLookup and @Min ...