TRY:


Code:
--------------------
=INDEX($C$1:$C$5,MATCH(MAX(IF($B$1:$B$5=$D$1,$A$1: $A$5)),$A$1:$A$5,0))
--------------------


Confirmed with CTRL+SHIFT+ENTER not just ENTER....

If you adjust the ranges, you will need to reconfirm with CSE keys....


--
NBVC

Where there is a will there are many ways.
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109086