i managed to get the below to work

=MAX(IF(J$9:J$1000=B9,I$9:I$1000))


id like to adapt this to include two criteria's like so but tis doesnt
seem to work

=MAX(IF(AND(J$9:J$1000=B9,L$9:L$1000=1),I$9:I$1000 ))


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=529923