Hi,

Array enter (Ctrl+Shift+Enter) the following formula

MAX(IF(($A$1:$A$4=A6),$B$1:$B$4)). Please format the cell as date.

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"ramudt" wrote in message
...
i am having the values as follows

PRODUCT MFGDATE
====== =======
AAAA 01-SEP-08
BBBB 02-SEP-08
CCCC 03-SEP-08
AAAA 04-SEP-08

if i enter the AAAA, i need the max date 04-SEP-08
if i enter in a cell BBBB, i need the max date 02-SEP-08

how to do this?
any one can help me?

Regards
Ramkumar