Excel 2007 : Lookup a value and return the latest date

Hi,

I have a set of data which is imported from Access that contains a list of contracts.

The contracts will relate to a product code - but there may be one or more contracts per product code.

I would like to look up this product code and return the last contract date.

I have tried a combination of MAX, IF, MATCH, INDEX etc., but can't seem to find the magic formula!

Thanks,

can you upload example workbook?

Zbor,

The data effectively is as:

Key Expiration Date
1 01/01/2001
1 01/01/2002
1 01/01/2003
2 01/01/2002
2 01/01/2005
2 01/01/2011
2 01/01/2004
2 05/05/2005
2 05/06/2005
3 04/05/2010
4 05/05/2010
5 06/06/2010
6 30/09/2011
7 06/12/2010
7 12/06/2011

So, I need to be able to lookup key=2 and return the most recent date (in this case 01/01/2011). I have done this so far just by sorting and filtering, but I am trying to set this up for people to run periodically as part of a much larger task and was hoping to have as little filtering/sorting/formatting as possible!

Many thanks!

Works a treat!

Thanks Sweep!