For a year in F2 (e.g. 2000) and month in G2 (e.g. 1)

=MAX(IF(($A$2:$A$1000=F2)*($B$2:$B$1000=G2),$E$2:$ E$1000))

confirmed with CTRL+SHIFT+ENTER

enter all your year month combinations in columns F and G and copy
formula down


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=521250