Hello,

Good Day...

If someone could help me with my problem.

I have this data on my worksheet, example; (please note: date format = dd/mm/yyyy)

Sheet 1
ID Number.......Date
10897.............01/01/2011
10896.............01/02/2011
10895.............01/02/2011
10896.............01/02/2011
10897.............01/04/2011

And in another sheet, i have to enter in a cell an ID number, adjacent to that cell should show the latest date that corresponds to that particular ID number in sheet 1, like for example;

Sheet 2
ID Number.......Date
10897............01/04/2011

Im using a vlookup formula, but the data i have from sheet 1 contains an ID numbers that may appear multiple times. vlookup searches for the first match it sees and does not display the latest date from that particulat ID number.

I hope you can help me.

Thanks.
Corine