Thanks, I got this to work. What I really need is a summary table on another
sheet. I've tried to modify the formula in cell B2 like this,
=MAX(IF((Sheet1!$A$2:$A$61370=$A3)*(Sheet1!$B$2:$B $61370=B$2),Sheet1!$G$2:$G$61370))
A B C D E
1 Y/M 1 2 3 4
2 1999
3 2000
4 2001
I cannot get it to work. Any other suggestions?
Thanks,
tlc



"daddylonglegs" wrote:


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